In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to create a reconciliation for 2 files, 1 vertical, 1 horizontal

Isha_Gupta
8 - Asteroid

Hi,

 

I have 2 files with many columns in each.

 

Both files have a common identifier.

 

In 1 file, for each identifier, every data is in horizontal way. Like, city, country, name, XYZ ID 1, XYZ % 1, XYZ ID 2, XYZ % 2 and so on...

 

In another file, for XYZ 1 and 2, it is in vertical.

 

Each ID will have 2 rows, 1 with same other columns like city, country, name but xyz 1 and the other row with again same other columns but xyz 2.

 

I want to reconcile xyz 1s, 2s in both files for each ID.

 

Any way to do?

1 REPLY 1
Raj
16 - Nebula

@Isha_Gupta Add some sample data will help with Workflow. Also add expected output.

 

Labels
Top Solution Authors