Excel Manipulation Using LinQ

Help Studio
, ,
1

DoubleNumberTableDoubt
In the attached Screenshot above table is the Input Table I need a LinQ for the below output table.

Thank you

2

Hi,

Can you try the following sample?

image
image806Ɨ422 18.1 KB

dt.AsEnumerable.GroupBy(Function(r) r("LOS_No").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key}.Concat(g.Select(Function(r) r("Loan_No_L").ToString).Distinct()).ToArray,False)).CopyToDataTable()

Sample
Sample20240319-5.zip (8.8 KB)

Regards,

3

Iā€™m getting the correct output but I missed one column(Without ā€œLā€) for both First Loan No & Double Loan No, can you please update your LinQ a bit?

UpdatedDoubleNumberTableDoubt
UpdatedDoubleNumberTableDoubt819Ɨ412 9.26 KB

4

@Yoichi Are you solving it?

1 Like
5

How about the following?

image
image782Ɨ416 17.7 KB

dt.AsEnumerable.GroupBy(Function(r)  r("LOS_No").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key}.Concat(g.Select(Function(r) Tuple.Create(r("Loan_No_L").ToString,r("Loan_No_L_Without_L").ToString)).Distinct().SelectMany(Function(t) {t.Item1,t.item2})).ToArray,False)).CopyToDataTable()

Sample20240319-5 (2).zip (9.7 KB)

6

Thank you so much for the quick solution!!!

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.