Create Combination 2 inputs with multiple steps

GgSs

Hi,

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

Input Data 1:

Name	Description	Step Type
AAA		PRE
BBB		PAST
CCC		PRE

Input Data 2:

Step Type	Step Number	Step Description
PRE	1	Ra ra ra
	2	Ca ca ca
	3	Ci ci ci
PAST	1	No no no

Expectation Output

Name	Description	Step Type	Step Number	Step Description
AAA		PRE	1	Ra ra ra
			2	Ca ca ca
			3	Ci ci ci
BBB		PAST	1	No no no
CCC		PRE	1	Ra ra ra
			2	Ca ca ca
			3	Ci ci ci

ScottE

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