Need a logic for below scenario

Help Activities
, , , , ,
1

Hi All,

I need logic to get output,

I have total 7 excel file.

And i have 1 excel file with i used for create out put

All the 7 excel file contain “ID” which is unique and primary key. but some excel sheet tne coulmn name may differ it show “ID_`num” like that but we need to look on values.

in output excel also we have “ID” coulmn.

i need to extract some values from all the 7 excel if ID is matched.
No match means leave it blanks. (Don’t delete in output excel)

Suppose in out put i am getting “ID” value row by row i search it 1st d1 if it is mached means i write it in out put else i leave it blank.

in every dt i have so many columns but i need to look specific column row value if “ID” is matched.

Below i attach screen shot,

Still any confusion please ask question i will replay back to you…

is it possible do it in LINQ means awesome for me…

image
image1679×527 16.8 KB

In above pic,

Expected out put is out put i need to fill.

only we have “ID” column row by row i search in all dt
i am getting ID is 100 need to search in dt1 if it is matched means i geeting only name from dt1.

if it is matched in dt2 i m getting gender only from dt2.

No match leave it blanks.

Thanks,
Vicky

2

@vicki1995,

Use Join DataTable activity to join all the table with Id column to Id column. Wherever you are not sure about the column name check it from DataTable before joining.

Thanks,
Ashok :slight_smile:

3

Cross reference / Duplicate

4

i updated my comments there but no replay from you there that’s why i created new ticket

5

Updated Requirement did not answered above 987 case

But still we gave one of many the options
Harmonize / Adapt all Join Col Names - eg. to ID