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