hi Kush
cannot share the data due to restrictions
im doing this in script
Old_Customer:
LOAD DISTINCT Customer,
Customer as Old_Customer,
1 as Old_Cust
Resident Table
Where businessdt<= '2020-08-31';
New_Customer:
LOAD DISTINCT Customer,
Customer as New_Customer,
1 as New_Cust
Resident Table
Where not Exists(Old_Customer, Customer) and businessdt<= '2020-09-30';
Temp:
LOAD DISTINCT Customer as Temp_Customer,
1 as New_Cust
Resident Table
Where Exists(Old_Customer, Customer) and businessdt<= '2020-09-30';
Lost_Customer:
LOAD Distinct Customer,
1 as Lost_Cust
Resident Table
Where not Exists(Temp_Customer, Customer) and businessdt<= '2020-08-30';
not able to get figure out
DROP Table Temp;
