Assume that you extracting the name, surname, age, and location values from PDF and you want to fill excel empty rows with the corresponding data.
Description and Details are headers.
Which way can I use to fill the data, Keep in mind we can have more rows to fill.
Please Help
Hey @Malusi_Ngubane,
Welcome to the community
After scraping you have set of values handy.
Access each field and assign value.
(DataTable.Rows.AsEnumerable.Where(function(row) row(“Description”).ToString.Equals(“Name”)).First)(“Details”) = Name value
Above statement can be accomplished using assign activity.
Similarly you need to follow for other fields.
If you are not comfortable with querying you can just follow traditional for-each row method and build logic inside it.
Thanks 
@Malusi_Ngubane- Take look at this workflow…This is exactly similar to what you are asking…You can ignore the activities which is not needed for you…
Main.xaml (18.9 KB)
This is my Input Datatable where i need to right the output in the “Value” Column.
Output: I have printed the datatable where the third column(Value) has been filled …
You can follow this approach and try it. (Ignore the Regex(column) if you don’t want)…
Mark this as solution, if it solves your query.
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123