topic Join two columns into one in QlikView

Join two columns into one

alerse — Wed, 18 Nov 2009 12:52:09 GMT

I've been struggling with this for a while now... I want to group two columns into one.

I got it working with :

if(len([rel_no])<>0,[rel_no],[Project]) as ProjRel

Project is fine but rel_no is just the ID, the description is in another table…

I've joined the tables but can't reference the Project field… This doesn't work:

left join("top table") load * ;

load

rel_no,

rel_desc as ProjRel;

SQL SELECT *

fRom relLookup

Any ideas?

Thank you!!

Join two columns into one

Anonymous — Wed, 18 Nov 2009 12:56:30 GMT

Hi,

One approach is to create a Mapping Table out of rel_no and ProjRel and then use ApplyMap() in your if statement to call the mapping table and pass rel_no in there and receive the matching ProjRel back.

Please see the F1 help and/or QV ref manual for the syntax.

Join two columns into one

alerse — Wed, 18 Nov 2009 14:04:23 GMT

Great, thank you! Exactly what I needed.