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?
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.
@clarrock
I will try with a batch macro.