Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Appending on basis of Id of Mapping

Mukeshy12390
8 - Asteroid

Hi Everyone - 

 

I have been trying to build solution where I need to append some data through mapping  based on "ID"  to input.

 

Here is the example . pls let me know in case any other details.

 

Input dataIDCode 
 mks123100 
 mks1234200 
    
    
MappingIDCode 
 mks12350 
 mks12340 
    
    
Target OutputIDCode 
 mks123100 
 mks12350 
 mks12340 
 mks1234200 
    
    

 

7 REPLIES 7
PhilipMannering
16 - Nebula
16 - Nebula

Judging by the output, it looks like all you want to do is Union the tables (stack vertically). Try the Union Tool

PhilipMannering_0-1605624277888.png

 

Greg_Murray
12 - Quasar

@Mukeshy12390,

 

Are you checking to see if the mapping ID values exist in the input before adding them in? If so, this should do it. 

Greg_Murray_0-1605624475364.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Mukeshy12390 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605625014665.png

Workflow:

atcodedog05_2-1605625067568.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

PhilipMannering
16 - Nebula
16 - Nebula

@atcodedog05 That looks very similar to my solution... I don't think the duplication is necessarily helpful.

atcodedog05
22 - Nova
22 - Nova

Sorry just happens to be a late submitter 😅 I had forgot to hit post.

Mukeshy12390
8 - Asteroid

Thanks everyone for the quick reply, all given solution work feeling so dumb right now:)

 

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @Mukeshy12390 

 

Chill its better know the answer then to be left with an answered question.

Please dont hesitate to ask a question and miss out one of the great ways to learn 🙂

 

Feel free to reach out if you face any issues 🙂

 

Happy to help 🙂

 

Cheers and Happy Analyzing 😀

Labels