Update column value in CSV file

Learning & Development Programs Reboot Your Skills 2021
, , , ,
1

Hello All,

I need to add data from web to CSV file column. but to write cell in CSV option is not there.
how to update status in CSV file. which activity to be used & packages also?

CSV columns
image

where i want to update “PO_Num” column value.

2

Hi @priyankamalusare,

  1. read csv - resultDt
  2. in for each row (resultDt)
    if row(“PR_NUM”) = 3670281
    Then Assign row(“PO_Num”) = “Your_PO_Num value”
  3. write csv

Thanks!

1 Like
3

Thank you so much it worked fro me :).

1 Like
4

Hi Dear,

My data is getting updated in correct row & column of CSV file. but i am also getting some extra columns attached in CSV. can you please suggest on this also. i am facing this issue after writing the CSV . values in CSV headers (column1, column2, column3…) i dont know from where this columns are coming

image
image1325×61 4.11 KB

image

5

can u share ur input excel sheet with dummy data and expected results in other sheet… i will try to implement…

or else share your xaml

@priyankamalusare

Thanks!

6

Hello Dear,

1)test.csv - file contain actual data with headers . (A-G). only 7 headers i have . i am updating column PO_Num & PO_Oracle_status in csv. which get updated using assign activty and write CSV file activity.

2)after using Write CSV file activty i got some extra headers in CSV file named as output.csv file

3)I just required (A- G) columns which are actual columns in CSV .

4)please note that i am not changing file name in xaml i have created two files now where in Xaml my input and output CSV has same name.
New folder.zip (28.6 KB)