How to create a reconciliation for 2 files, 1 vertical, 1 horizontal
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Isha_Gupta
8 - Asteroid
‎01-25-2024
12:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Help
1 REPLY 1
Raj
16 - Nebula
‎01-25-2024
12:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Isha_Gupta Add some sample data will help with Workflow. Also add expected output.
