Attrition of Employee

[#1]

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

[Anonymous]

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

[#3]

i have to do it on the frond end

please let me know if adding a column will help

[Anonymous]

can you provide an example of your required chart?

[#5]

Hi,

please find the attached image the chart required

[#6]

Could you add two columns to the model that will point out the first quarter of emloyment and the lasat quarter of emloyment?