I have one datatable dt1 which i have through Data scraping and I’m using rows of particular column in dt1 as search parameter and scraping result set into another datatable dt2 and writing that data into CSV.Is there anyway I can have search parameter into column and append that to dt2 and write into csv.
I can’t use join here as both tables doesn’t have unique identifier.
To be more specific:
Dt1 column Employer ID(Search parameter for dt2)
when search generate results with columns Employer name , Status , Location (dt2)
I need to create a datatable dt3 with Employer Id ,Employer Name ,Status , Location
Welcome to the Community!
Not sure if I understand you correctly but please check Append Range activity with which you can add data to the table without removing existing data. Hope this helps