2 questions on TRANSFORM

edited December 2023 in General

Looking for ideas from community.

1)   Transform – ‘Equals’ Command

I am in a workflow to check if the input file matches to data loaded in SAP Table. There are about 70 columns and I want to create new 70 check columns as follows:

field1_input equals field1_Sap

field2_input equals field2_Sap



field70_input equals field70_Sap

Is there any easy way to define the 70 fields other than defining them one by one?

2)   Transform – ‘And’ command

Once the 70 columns are defined, I want to define another column to True if all the fields are True using the And command. Here again, is there any easy way other than manually picking all the 70 columns to the And command?