why not concatenate first 2 tables since fields are same except dates...
And 3 table would link to your single tables based on Person ID
Not sure if this would work...?
0 as Hire Date
From App Data;
0 as Application Date
From Hire Data;
From Start Data;
If I could I'll concatenate all 3 tables but other may have different or easy approach
They are coming from three separate systems with direct pipes to Qlik and the examples were simplified for posting sake. They are all tables with cell counts in the 8-9 figure range. I could write a script in Excel to concatenate, but that defeats the purpose. The issue is that one employee might have five start dates. So I need to identify what start date belongs to which Employee/Job Id combination.