Spliting Data

clarrock

Hi,

I have two input Datas sheets

1. 

Ccy	Check ABC	Check DCD
EUR	Yes	No
USD	No	Yes
CHF	No	No
ZAR	Yes	Yes

2. Main

Ccy	ABC	DCD
ZAR	0	16
ZAR	17	18
EUR	18	50
USD	10	19
EUR	0	21
CHF	23	5
ZAR	-5	6
CHF	1	0

I need the main splt to below output based on the 1st Table being Yes under either Check ABC or Check DCD, if they both are Yes for a ccy then i need a split for both ABC and DCD 

Output i'm trying to get:

Ccy	ABC
EUR	18
EUR	0

Ccy	DCD
USD	19

Ccy	DCD
ZAR	16
ZAR	18
ZAR	6

Ccy	ABC
ZAR	0
ZAR	17
ZAR	-5

Is this possible on Alteryx?

DavidP

Hi @clarrock this is how I would approach it:

Transpose both tables so that you can isolate all the Yes's.

Use a join tool to assign values to each relevant Yes check.

assign values to Yes checks.yxmd