I have one downloaded csv file. in that we need to add client number in ‘A’ column thought out all the rows.
I have used these activities
After these while write to csv. i’m getting only ‘A’ column values not other values.But i need all the values.
Suggest me how to achieve this
Hi @sindhura506
I assume you already have a column to have the client number
Use the below steps:
use Read CSV to read the data to a data table
Use a For Each Row activity to loop through the values in the datatable
Add an assign activity within the loop
use the following expression to assign the value to the datatable column
row("ColumnName") = ClientNumberVariable
This will assign the number to all the rows.
Is that what you need?
Yes, that is what i’m doing. But after assign the number i’m writing the Data table to csv file.while writing to csv old data table is coming. newly added data row is not affected.
I need 1st column modified data with old columns data.
Hi @sindhura506
So you are adding a data row to another data table here right? But you are using the same datatable variable that was used to read the csv file to write to the excel.
You should use the datatable associated with the add data row activity to write the data to excel.
Let know whether it helps
Oh hang on… that datatable should also work… because you are assigning it… hmmm… check whether actually a value is getting assigned there. Debug mode will help to understand that. Add a break point there and check the data
@Lahiru.Fernando
adding row.Item(0) assigning the value.but the problem it is considering all columns in row as single cell
@Lahiru.Fernando
I don’t have column name so, i have used column index but unable to get the all columns.
Hi @sindhura506
Can you share your workflow so that I can have a look? also the excel file if possible
zip the two files and attach it 
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu