Write to CSV

Help
, ,
1

Hi,
I need to write the extracted data in a CSV file.

lk
lk1180×123 5.86 KB

The values of the column that I have highlighted are taken from each row, whereas the other column values are extracted from PDF. I am entering the data once all the process is done. So I AM facing the error that as the first two values are in for each while writing the data, at last, it gives me only the last value of each, not each value. How to pass the each value to the CSV file after all the process is done

2

Hi @soumi_soumiya

you can do one thing

create a build datatable activity with given columns given

use add data row activity and pass the values within array row

and then use write csv activity

Thanks
Ashwin S

1 Like
3

Thanks for your reply
Yes i have done the same but my problem is that my for each ends first and then only the data will get extracted from pdf after scraping i am writing the scraped values in CSV file. I need to add the id and date which is in for each data table where my condition that i have passed is true.
So at this stage the last value is alone taken not the all

4

Hi @soumi_soumiya
you mean to say you are not able to add invoice no and other column values

Thanks
Ashwin S

1 Like
5

No i am not able to add first two values