How to add Column on Specific Position

Hello,
I am trying to add Column on specific position in CSV(Column L1) and add data from excel. I tried using Add Data Column but it is adding on 1st position.

2 Likes

hi @sneha_arbole
got through the below loop

can i see your xaml.Theres a lot of way how to add column … you can add in datatable or in excel it self… :smiley:

@sneha_arbole

cheers :smiley:

Happy learning :smiley:

1 Like

the main data is in CSV format…can i add the extracted data in CSV File directly on specific column?

Ok lets create a scenario.

Scenario
1.You read the csv file using Read CSV Activities.
2.It will return a Datatable ?
3.The return datatable will be writen in excel Using Excel applcation scope and Write Range?
4.Question how do you want to write the additional colum ?

cheers :smiley:

Happy learning :smiley:

1 Like

This is my CSV file i want to write data on L1 Column.
pubmed_result.zip (232.8 KB)

@sneha_arbole
Refer this post to add column into specific position.

2 Likes

Do you want me to put new column after the column(“Properties”)

cheers :smiley:

Happy learning :smiley:

1 Like

Yes i want it after properties Coumn

1 Like

Do you have any specific value to write or do you want me to create dummy date to be written in the additional column ?
@sneha_arbole

cheers :smiley:

Happy learning :smiley:

2 Likes

i have specific data which is string format.

1 Like

Hi @sneha_arbole

1.I can use foreach row to modify the excel if you have string format.I just need to know what is the format of your string so that i can create a logic on it on how to apply it in our process.
2.I can easily input colection of data to add in our new column in our dattable like this.

cheers :smiley:

Happy learning :smiley:

1 Like

PubMed.xlsx (109.5 KB)
This the data i am trying to write in csv column.

Thank you very much in advance

1 Like

Hi @sneha_arbole
Kindly see the attachment for your reference. Hope this might be helpful to you :smiley:

pubmed_result_Test - Copy.zip (800.3 KB)

cheers :smiley:

Happy learning :smiley:

2 Likes

Thank You Very Much

Your most welcome @sneha_arbole

Happy to help here :smiley:

cheers :smiley:

Happy learning :smiley:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.