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.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How can I cross-tab rows after transposing 2 datasets and filtering?

illadelphia
6 - Meteoroid

Hi, 

 

I am trying to crosstab row records that are mismatching after doing a transpose on both datasets and filtering out mismatching rows. Here is my workflow so far and some sample data in a screen shot:

 

So as you can see below, I have done some work on the data to get it to compare on individual fields (there could be 5 fields there could be 500 depending on the file) and would only care about the Row Records coming off the False branch (i.e. mismatched data per field). So I have the record IDs and want to cross-tab these False records back into their whole rows in a Left Table vs Right Table view.. Is this possible?  

  

Capture37.PNG

This is how I currently have my final output data and basically looking to remove rows from both files that are not highlighted.

Capture38.PNG

 

I have attached the workflow I got inspired by to modify for my use case. 

 

 Thank you

0 REPLIES 0
Labels
Top Solution Authors