How to append specific record from Mapping file

Hello Team,

I have data set in which some customer name and number is missing. To update the missing customer name and number, I have spread the Mapping file.

With the help of this file, I updated the missing data manually, Could everyone help me to design a flow to update those missing records automatically.

I have attached the sample data

Data Set Mapping.xlsx

Sample Data Set.xlsx

Help

Accepted answers

binu_acs

@Learner09 if you want the non-matching records also then add a union tool and connect with the J and L - anchor of the join tool.

Join.yxmd

All comments

nitinsnow

Hi @Learner09 : Attaching the solution. If sounds good, please accept it as a solution. Thanks.

Mapping_Solution.yxmd

Mapping_Solution.yxzp

Qiu

@Learner09
If I am not mistaken, A Join Tool should do the work.

1227-Mayank09.yxzp

Learner09

Thank you @Qiu for the Flow. It's working fine, but I provided the sample data, in actuality I have 26000 lines of data and there are customers who don't need any name or number update. This flow only picked the specific customer (who are present in the mapping) and dropped the rest of the data. I need all my 26000 rows with these specific (Mapping list) customer names and number updates.

Learner09

@nitinsnow Same problem (please refer to my reply to @Qiu ) it only picking the Mapping Client list and showing blank rest on the customer name and number

Thanks,

Learner09

@binu_acs Thank you, It's working!

Qiu

@Learner09
Glad to know there is a one flow working.

Sorry did not reply any sooner.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703