Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Splitting

Newtoalteryx
7 - Meteor

Hey,

 

I have created a workflow which gets input 1 and produces output 1 as shown in the image. Here are all the other possible inputs. Input.png

 

I want to be able to get corresponding outputs (output 2 for input 2) as shown here:

output.png

 

Please let me know how to achieve these. Would appreciate any feedback!

 

Thanks!

 

2 REPLIES 2
binuacs
21 - Polaris

@Newtoalteryx Create a text input tool with all the columns and the values as NULL then union with your original input files,sample attacahed

image.png

Newtoalteryx
7 - Meteor

Thank you! Just did the same thing myself

Labels
Top Solution Authors