Add new values to data table

I have an excel file that lists five countries.
I read this as a Read Range and made it a DT. (Let’s call it dtNew)
Then, by using For Each Row, I try to retrieve the exchange rates one by one by pulling out the countries contained in the DT to be created above.
If the extracted country is the United States, after retrieving the US exchange rate, import the value to Get Text and add it to the DT. (Create a new “Exchange Rate” column)
How can I add it to dtNew after getting it with Get Text?

Hi @dlqhqo98

Welcome to forum

When u are creating excel itslef try to create column for the exchange rate tok

Now after u get the exchange rate data using get text

Then using assign activitiy

row(exchange rate column Name) = value from get text

Using assign activitiy u can able to save the exchange rate for corresponding row of country


Nived N


Welcome to forums

Dt.Rows(index).Item(Columname) = Your value

For Reference check below
Hope this may help you



1 Like

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