Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Data Comparing and Summary

subbarao
7 - Meteor

Hi, I have 2 datasets and trying to figure out an easy way to compare the data...

 

Dataset 1 - 

 

IDMetric 1Metric 2
A11010
A22020
A33030
A44040
A55050
A66060

 

DateSet 2

 

IDMeasure 1Measure 2
A11010
A22120
A33033
A4 40
A55550
A660 

 

Output Dataset

 

IDMetric 1Measure 1Test 1Metric 2Measure 2Test 2
A11010Y1010Y
A22021N2020Y
A33030Y3033N/A
A440 N/A 45N
A55055N5050Y
A66060Y60 N/A

 

I was able to achieve this using Join and creating the Test 1 and Test 2 using Formula

I have 100 such Metric/Measure combinations I want to compare. Wanted to check if there is an easier way....

 

I also want to create a summary of the test results - 


Dataset 3 (Subset of Output above)

IDTest 1Test 2
A1YY
A2NY
A3YN/A
A4N/AN
A5NY
A6YN/A

 

Desired Output - 

 

 YNN/A
Test 1321
Test 2312

 

I was able to achieve this by Selecting each column and doing a union and transposing the data. 

But again, is there an easier way to aggregate 100 columns which does not require the need to do 100 selects...

5 REPLIES 5
ponraj
13 - Pulsar

Here is the dynamic workflow you are looking for.  Hope this is helpful. 

 

WorkflowWorkflowResultsResults

 

 

subbarao
7 - Meteor

This worked great. Is there any way I we can get the Output Dataset?

ponraj
13 - Pulsar

you can use output data tool instead of browse tool to write results in whatever file format you want. Hope this answers your queries. 

subbarao
7 - Meteor

Sorry, I was not clear.

My question was - how do I get to "Output Dataset" view posted in my original question (Same view posted below)

Without using Join and formula for each column I am testing...

 

Output Dataset

 

IDMetric 1Measure 1Test 1Metric 2Measure 2Test 2
A11010Y1010Y
A22021N2020Y
A33030Y3033N/A
A440 N/A 45N
A55055N5050Y
A66060Y60 N/A
ponraj
13 - Pulsar

Here is the dynamic workflow you are looking for.  Hope this is helpful 

 

WorkflowWorkflowDataset 3Dataset 3OutputDatasetOutputDataset

Labels