Hello everyone, I did an automation that can extract text and paragraphs to Google Sheets. And is it possible to extract the whole paragraph in one row on the C column? I used table extraction to indicate the paragraph and it gonna extract it in each rows

[Knowledge]

I used table extraction to indicate the paragraph and it gonna extract it in each rows

[arivu96 (Arivazhagan A)]

Hi @Knowledge,

We need to change the selector bits to achive, if thats not possible we need to concadinate the “C” column values if the “A & B” columns are empty.

dtResult = dtInput.Clone()
dtInput.AsEnumerable().GroupBy(Function(r) r("A").ToString()).Select(Function(g) dtResult.Rows.Add(g.Key, "", String.Join(",", g.Select(Function(r) r("C").ToString()))))

OR

dtResult = dtInput.Clone()

(From g In dtInput.AsEnumerable()
 Group g By key = If(String.IsNullOrWhiteSpace(g("A").ToString()), "temp", g("A").ToString()) Into Group
 Let mergedCol3 = String.Join(" ", Group.Select(Function(r) r("C").ToString()))
 Select dtResult.Rows.Add(If(key = "temp", "", key), "", mergedCol3)).CopyToDataTable()

Regards,
Arivu

[Knowledge]

Hi @arivu96, thank you for helping me I’m not good at it because it began to tried it a few days ago. If is it okay can you tell me where should i put this variable?

[arivu96 (Arivazhagan A)]

Hi @Knowledge ,
Welcome to UiPath community Forum

Please go through this
Sequence1.xaml (8.9 KB)
Book1 (1).xlsx (9.6 KB)

Regards,
Arivu