Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 4 Quarters of data
say Q1 2014
Q2 2014
Q3 2014
Q4 2014
these are 4 different files.
to check we have given a number to each file 1,2,3,4
i have added one column in each file
'1' as Num
'2' as Num
'3' as Num
'4' as Num
now we have to check which employee are present in Q1 2014 but not in Q3 2014.
please reply thanks a lot
try to use not exists
for example:
Q3:
load *
from file3;
Q1:
noconcatenate load *
from file1
where not exists(employeeid)
this is not exact what you want, provide an example so we can further help
you should describe what you want with these quarters
i have to do it on the frond end
please let me know if adding a column will help
can you provide an example of your required chart?
Hi,
please find the attached image the chart required
Could you add two columns to the model that will point out the first quarter of emloyment and the lasat quarter of emloyment?