File comparison
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2024 12:59 AM
Hello Geeks,
I have two csv files, lets say X and Y
We have a JDBC file loader where we extract these csv files from MidServer.
X has columns - DeviceID, UserID, enrolledDateTime
Y has columns UserID, userEmail
I want to compare the X and Y csv files with a matching UserID field and create a new csv file with columns DeviceID, UserID, enrolledDateTime, userEmail on which I want to apply a transform map and load into target table.
0 REPLIES 0