I have the following use case. I have employee information, employee training information, and employee payroll information coming in three separate files. I am trying to load files from google drive and trying to find various aggregations on the total data set.
Example: Total employee hours spent on each training, Gender-based break up for training data, Age group, gender-based payroll data, etc.
I am running into these problems in the design -
- Look up from google drive only has only "look-up additional files per record" and there does not seem to have an option to merge records back with the original source record.
- If I bring in all the files as exports instead of look-ups, based on various community posts and articles, it looks like all the sources should have the same fields for the flows to process correctly. I could not find any ways to merge records based on a common field or unique IDs.
Could you please suggest how I can solve this issue? If you could point me to any relevant resources it would be great.
Please sign in to leave a comment.