I was hoping to use the IF THEN logic(or something similar) within the LOAD... I don't do a LOAD * because I'm only pulling in a subset of variables and also using TEXT(), APPLYMAP() etc. There are a few fields (in the example var11-var13) that are only available for a certain source that I would like to include if run for that source...
TEXT(var2) AS var2,
IF $(vSource) = 'Source' THEN
I don't think it is possible with the load, but you can set up a variable before to check which fields you want to bring in. For instance you have 6 fields: F1, F2, F3, F4, F5, F6 and you only want to bring last three when it is from a specific source, then you can try this
LET vFields = If($(vSource) = 'Path....', 'F4, F5, F6', '0 as Dummy');