Hello,
I am experiencing issues with OACS Data flow. I am trying to create an Assignment table using the HCM Cloud Subject area and then create a Prior Assignment table that stores previous information for the same employees. Now, if I make a visualization I am getting perfect results. Ie. for the first employee assignment from the Assignment table, will not have any prior assignment record in the Prior Assignment table. This is working as per my expectations and joins work perfectly fine. I can even create calculations of what got changed. However, I am designing Data Flow which reads both these tables and make new Table called Events and this will store all change flags instead of creating these calculations in each time. For example is there any change in location etc.
Now the problem I see, when flow runs, it adds extra empty rows for each Assignment record which does not happen if I create a report. So need to understand how flow executes queries differently than regular reports and how this could be fixed.
Thank you all for your help.
