How to Map data from 2 file --> Linq

Help Activities
, ,
1

I want map data from 2 file

  1. file input
  2. file map data (In real data have 100K row)

I have file input as below.
image

I want match column App for all sheet except sheet output.

and have file for map data as below.

image
image705×157 7.39 KB

If value column APP in file input have found in Column APP in file Mapdata.

I want to copy data in column ADR1_2 , CLTADDR03 , CLTADDR04 , CLTADDR04 , CLTPCODE to column Address1 , Address2 , Address3 , Address4 , Address5 in file input.

image
image981×104 4.93 KB

Please guide me for solve it.
input (4).xlsx (15.1 KB)
map data.xlsx (9.0 KB)

1 Like
2

@Robinnavinraj_S @kirankumar.mahanthi1

3

@fairymemay

Try with Join Datatable activity

Hope this may help you

Thanks

4

@Srini84 How to use join datatable ?

5

@fairymemay

Check below for your reference

Thanks

6

Hi may

Please find the attached overall project
May.zip (5.2 KB)

Thanks
Robin

7

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