Joining fields when it is a specific value

[#1]

I want to join three fields together but I only want the third field to show if it is a specific value. What is the best way to do this in the script?

For example, I have three fields: Product, Location, Color. I want to combine product_value + location_value + color_value (only if it is yellow). If it is not yellow, then I only want the new field to have Product_value + Location_value.

[preminqlik]

if i understood

Load Product_value,Location_Value

from table1;

join

Load Product_value ,

Location_Value,

Color_value

resident table2 where Color_value='yellow';

[Anonymous · Accepted solution]

You can concatenate in the load script.  See attached.

[#4]

I still need those product and location fields so I used the below to create a new field....

if(Color='Yellow',Product & Location & Color,Product & Location) as NewField

Thank you very much for your help as it was very helpful.