Write data in Existing Column

Hai…

How to write data in Existing column , which is Dynamically changing its position…?

Thanks in Advance

If the Data is in Excel , Then read without the headers . So the lookup can be used to check the index.

Or

Read the Data to datatable and use linq to get the list of column names . retrieve only the text that contains in array and get the index of array

@sumitha_karthik

Read the data with add headers checked and use the column name instead of index so that even if position is changed it gets updated

Cheers

Hi @sumitha_karthik,

If you can guess the expected column name use “Update Row Item” Activity like below

image

Thanks,

1 Like

Its worked… Thank you…!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.