Join two columns into one

[alerse]

Hi

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!!

[Anonymous · Accepted solution]

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.

[alerse]

Great, thank you! Exactly what I needed.