Capture field names to pass to Multi Row Formula

[jwycoff1]

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

[jasperlch · Accepted solution]

Hi, you could make use of the Transpose tool to make your workflow more dynamic

[jwycoff1 · Accepted solution]

Exactly what I was hoping for! Elegant and simple. THANK YOU!!!