Forum Discussion
Add column based on value other query
Hi all! I have a dataset with two queries on a group of employees. Query A loads data from a monthly updated database, where I've applied the step to only keep the data for the snapshots wit...
Hi Nipius,
I'm not so clear for 'query B' data structure, can you please explain more about this?
How to Get Your Question Answered Quickly
In addition, you can consider to add column to extract and merge year part and employee id to create a bridge table to link two tables.
Regards,
Xiaoxin Sheng