topic Re: Derive additional column on existing table during Load in QlikView

Derive additional column on existing table during Load

Wed, 15 Apr 2015 03:48:11 GMT

Hi!

Is there a way I can derive an additional field on existing table during the LOAD?

Sample Output:

Final Status column will be my additional/derive field based on the initial Status field on my existing table.

Appreciate your help.

-Bea

stigchel — Wed, 15 Apr 2015 08:48:40 GMT

You can do a load from an existing table using resident, if you want add (join) the column to the existing table use a join load. Something like:

Join (SourceData) LOAD

ID,

If(left(Status,4)='pass','Passed',If(left(Status,4)='fail','Failed')) as [Final Status]

Resident SourceData;

Ralf-Narfeldt — Wed, 15 Apr 2015 08:51:20 GMT

Add a preceding load that adds the Final Status:

Load *, If(left(Status,4) = 'fail', 'Failed', 'Passed') As [Final Status];

Load * inline [

ID,Status

Abc,pass

Def,pass (with special cases)

Ghi,fail];

This is based on your input data, if you have more possible values, you may need to adjust the If condition.

Wed, 29 Apr 2015 08:24:14 GMT

Works perfectly! Thanks!