How to get all possible combinations after concatenating 2 Cells from 2 Excel Columns?

[hsendel]

Dears,

How to get all possible combinations after concatenating 2 Cells from 2 Excel Columns Using UiPath ? If I’m not wrong we should get n to power of 2 Using Algebra Bellow is an explanation :

Thanks in Advance

[Yoichi]

Hi,

How about the following?

dtResult = dt.AsEnumerable.SelectMany(Function(r) dt.AsEnumerable.Select(Function(r2) r(0).ToString+r2(1).ToString)).Select(Function(s) dtResult.Clone.LoadDataRow({s},False)).CopyToDataTable

Sample20210709-1.zip (8.9 KB)

Regards,