I would like to add on to Find Changes in database extracts
This worked for me, but I have to code a new expression every time the input file changes, and potentially , the number of names can be 100 or more.
Is there a simple way to capture the field names of the input file, then generate the expression? Using variable substitution?
I'm not seeing how batch macro would work.
Something like
IIF([$Field1]!=[Row-1:$Field1], "$Field1;","") +
Doing variable substitution so,
IIF([Field1]!=[Row-1:Field1], "Field1;","") +
IIF([Field2]!=[Row-1:Field2], "Field2;","") +
Thanks!
--JJW
Solved! Go to Solution.
Exactly what I was hoping for! Elegant and simple. THANK YOU!!!