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)