Assigning values in datatable (data scraping) to variables

Hi

We can use default view method

That is if the datatable is saved in a variable named dt once after data scrapping then use a assign activity like this

dt_1 = dt.DefaultView.ToTable(False,”Column-1”)

And another assign activity like this

dt_2 = dt.DefaultView.ToTable(False,”column-2”)

This will save as two different datatable

Hope this would help you

Or
you can get them as two different data columns like this

In a assign activity
dt_col1 = dt.Columns(0)

And another assign with
dt_col2 = dt.Columns(1)

Where both dt_col1 and dt_col2 are of type System.Data.DataColumn

Cheers @SH_94

2 Likes