2 questions on TRANSFORM
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?