Sum of multiple fields from a undefined collection

[ruggs]

I have an Excel file that I have added as an undefined collection.
Its got almost 200 columns so I'd like to avoid mapping them

I need to take a sum of about 10 of these columns
I'm not sure how to reference the columns to add them together per each row
Final results will be output to a new field in the same table for each row

Any help would be greatly appreciated.

 

[Sukesh Kumaru]

Hello,

After performing addition operation, store that result in a new data item and then create a new column in that collection and pass that resultant value to that column value after each addition operation.

Good Luck.

 

[SERBEM]

I build a few processes in windows like that, you need to send tab and global key events. Sometimes you can spy each field in UIA mode or AA mode when you have activated the specific field

 

[ruggs]

Hello,

After performing addition operation, store that result in a new data item and then create a new column in that collection and pass that resultant value to that column value after each addition operation.

Good Luck.

That's the problem, I don't know how to reference specific fields using an undefined collection (if it was defined it would be a simple matter but referencing those columns/fields is the challenging part)