topic Re: Merge one field into another in QlikView

Merge one field into another

tom2qlik — Mon, 08 May 2017 11:26:21 GMT

Hi all,

I am trying to move values from one field into another. Currently I have my dataset looking like below:

This table is created by left joining on number with the pulling field being location2.

I want to move the values from location2 into the location field.

Thanks,

Tom

Anonymous — Mon, 08 May 2017 11:34:54 GMT

Hi,

This will give you required output.

LOAD Number,

Pallet,

if(isnull(Location),Location2,Location) as Location,

Location2

FROM

(ooxml, embedded labels, table is Sheet1);

Thanks

Paridhi

prma7799 — Mon, 08 May 2017 11:40:58 GMT

Try this....

Test:

LOAD * Inline [

Number ,Pallet,Location, Location2

1 ,1aaa ,London ,

1 ,1aab ,London ,

2 , , ,Paris

2 ,2fbb , ,Paris

3 ,3Sab ,Madrid ,

3 ,3Sad ,Madrid ,

]

;

TestNew:

LOAD Number ,Pallet

if( len(trim(Location))= 0 , Location2 ,Location ) as NewLoc

Resident Test ;

drop Table Test;

sunny_talwar — Mon, 08 May 2017 11:47:17 GMT

If only one or the other will ever have a value, you can just do this

Location & Location2 as Location