About Getting Duplicate Values in Different Columns in Excel

Hello Friends! I am scrapping data from summarization from Text Analysis api demo website using url from excel. I am getting 4 sentences extracted from url. I am trying to Write Extracted Sentences into different columns in Existing Excel in Sentence 1, Sentence 2, Sentence 3 and Sentence 4 Columns in Excel sheet.
I have used Write Cell inside for each row in for each loop But I am getting duplicate sentence in 2 different column in Sentence1 and Sentence2 column in Excel.
Please suggest me proper solution to this Problem.
I am attaching flow, screenshot of flow, Excel File and Process.xaml.





scrappingSentenceDemo.xaml (21.9 KB)
OlamProjectData.xlsx (11.8 KB)

Regards
Rohit Lanjewar

@RohitSuperCool009

You’re writing the same value in C and D column .row.item(0).tostring.
Could you share the output of msgbox row.item(0).tostring

Thanks,
Suresh J

Thanks sir! for your early response. Surely. I am attaching all Output Msg Box Screenshot. Please refer it. I am getting all 4 sentences properly in Message box after running process properly. Please suggest me proper solution to Write these All Sentence values in Excel in different columns.

PFA
Regards
Rohit Lanjewar

msgbox1

SecondMsgBoxOutput
FourthMsbBox ThirdMsgBoxScreenshot

@RohitSuperCool009

Please find the column iterate logic which will be working for you.

Thanks,
Suresh JSequence.xaml (11.6 KB)

1 Like

Ok Thanks Sir!! I would try with this flow, and let you know.

Regards
Rohit Lanjewar

1 Like