How to append specific record from Mapping file

[Learner09]

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

[nitinsnow]

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

[Qiu]

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

[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,

[binuacs · Accepted solution]

@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. 

[Learner09]

@binuacs Thank you, It's working!

[Qiu]

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

Sorry did not reply any sooner.