Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to append specific record from Mapping file

Learner09
8 - Asteroid

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

7 REPLIES 7
nitinsnow
Alteryx Alumni (Retired)

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

Qiu
20 - Arcturus
20 - Arcturus

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

1227-Mayank09.PNG

Learner09
8 - Asteroid

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
8 - Asteroid

@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
20 - Arcturus

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

binuacs_0-1640613490969.png

 

 

 

Learner09
8 - Asteroid

@binuacs Thank you, It's working!

Qiu
20 - Arcturus
20 - Arcturus

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

Sorry did not reply any sooner.

Labels