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.
