Working on one of the Project where adding data to row

[mittal.abhishek]

where i am building a datatable (Col1 & Col2) after that in for each adding item to collection with 2 different list but finally when i am adding the data to row {old file name , new file name} eventually writing to excel file with write range activity

Issue facing - bot writing the output in column1 only instead of writing column 2 also refer the screenshot below :

Any solution on this , Thanks in advance !! cheers…

[johnfelix (John Felix Yesuraj)]

Hi @mittal.abhishek

Could you please share your screenshot or code of for each loop.

[loveleet_Saini]

Hi @mittal.abhishek

Please Share the code.

[mittal.abhishek]

WS_FTP_PRO_SharedDraft.xaml (300.3 KB)

[mittal.abhishek]

PFB :
WS_FTP_PRO_SharedDraft.xaml (300.3 KB)

[Emira (Emira Gasmi)]

Hi
Can you share the directory of the project?
Packages are missing and we are unable to open the xaml.

[mittal.abhishek]

project.json (1.5 KB)

[Pradeep_Shiv]

Hello @mittal.abhishek

You are writing both the values on a same Index (0), try changing it.

Please find the image for your ref, I’ve added Empty String for Previous File name in List2 and Empty String for NewFileName in List1

try like this and let us know

[mittal.abhishek]

Hey It’s writing on 2 column but starting from B10 cell like below

It should write from B2 column

[johnfelix (John Felix Yesuraj)]

Hi @mittal.abhishek

Please replace the Add Data Row activity in second for each with Assign activity like below.

Create an Index variable in second For Each activity property like below

Note:
Add Data Row activity always add value at the end.
To update the value in existing row we need to use assign activity.

OutputDt.Rows(indx)(1)

(Indx) variable represents the row position
(1) Represent column position

Thanks
John

[mittal.abhishek]

Thanks John Perfect finally got the output as expected…

Cheers !!