Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
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.
Great, thank you! Exactly what I needed.