How to get exact data like specific column in excel

[Mathkar_kunal]

Hello,

my expected data

getting B &c column data using 1 api , d column data using 2 nd api and F&G column data using 3 rd api.

requirement is i need to generate H column and data should look similar to D column.
but i am getting below data as per my logic

i am not copying data from d to h because data in f & g will be less than b &c like below

or names in g will be different than c in some cases so in that case i will not generate h coluns for perticular i will right not matching.

how can i generate data as per expected result which i showed in 1 st image
help me one same

[Dinesh_Guptil]

hi @Mathkar_kunal
can you send expected output image

[Mathkar_kunal]

here is the expected output i

[Dinesh_Guptil]

Hi @Mathkar_kunal

try This

DT = DT.AsEnumerable.where(Function(r) r(“User ID POD”).ToString.Equals(r(“User ID DC”).ToString)).CopyToDataTable

It Helps!

[Mathkar_kunal]

tell me range for DT(for read) and whre should i write dt again ? from F or I

[Dinesh_Guptil]

Hi @Mathkar_kunal

1.Dt is the output of read range workbook
2.take assign
LHS =Dt
RHS= given syntax

It helps!