Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
This will give you required output.
if(isnull(Location),Location2,Location) as Location,
(ooxml, embedded labels, table is Sheet1);
LOAD * Inline [
Number ,Pallet,Location, Location2
1 ,1aaa ,London ,
1 ,1aab ,London ,
2 , , ,Paris
2 ,2fbb , ,Paris
3 ,3Sab ,Madrid ,
3 ,3Sad ,Madrid ,
LOAD Number ,Pallet
if( len(trim(Location))= 0 , Location2 ,Location ) as NewLoc
Resident Test ;
drop Table Test;
If only one or the other will ever have a value, you can just do this
Location & Location2 as Location