@TSummers1, yes looked like you were using “ConfirmationNumber” and “AmountPosted” as your column name.
If you look at the images I posted above.
The ForEach you are using loops through each row, then you access each column from that row.
(Referencing the above images)
ForEach row in mydata
Account = row.Item(“Client Account Number”)
row.Item() or row() will access the column within that row. Technically you can use the variable name “column” but you are really looking at the row so “row” makes more logical sense is all
Now, the important thing to know is that you can change the value of a column within that row to include the CFR_Num and CFR_Amount. You can simply do that with an Assign activity like:
row.Item(“CFR_Num”) = CFR_Num_From_MM
row.Item(“CFR_Amount”) = CFR_Amount_From_MM
Please reference the images above as example as well.
And, like I mentioned if the column does not exist that you want to store the CFR_Num and CFR_Amount in, you will need to use “Add Data Column” right after you do the “Read Range” initially.
OKAY, after you have assigned the CFR_Num and CFR_Amount into the datatable which is also shown in the images above that you can reference, you will just do your Excel Scope with “Write Range”
All you need to write is the entire datatable with the updated columns that were done using the Assign activities shown in the images above.
Hope that cleared up some things.
Let me know if these updates help you out.