Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Create Combination 2 inputs with multiple steps

GgSs
5 - Atom
‎12-19-2022 07:06 AM

Hi,


I'm looking for an Alteryx workflow for below case. Please advise...

 

Input Data 1:

NameDescriptionStep Type

AAA

 PRE
BBB PAST
CCC PRE

 

Input Data 2:

Step TypeStep NumberStep Description
PRE1Ra ra ra
 2Ca ca ca
 3Ci ci ci
PAST1No no no

 

Expectation Output

NameDescriptionStep TypeStep NumberStep Description
AAA PRE1Ra ra ra
   2Ca ca ca
   3Ci ci ci
BBB PAST1No no no
CCC PRE1Ra ra ra
   2Ca ca ca
   3Ci ci ci

 

Labels:
Reply
2 REPLIES 2
ScottE
Alteryx Alumni (Retired)
‎12-19-2022 07:25 AM

Hi @GgSs 

 

You can use the Multi-Row Formula to fill in the missing values and then join the data sets together.  The attached should work for you.

 

Hope that helps,

Scott

JoinDatasets.yxmd
Reply
Felipe_Ribeir0
16 - Nebula
‎12-19-2022 11:37 AM

Hi @GgSs 

 

One way of doing this

 

Felipe_Ribeir0_0-1671478629006.png

 

Create Combination 2 inputs with multiple steps.yxmd
Reply
0 Likes
GenAI Contest Form
Community Live Fifa Workshop
Labels
Top Solution Authors
View All