Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
I have to create a report for a particular scenario-
Option1:
Step 1. Client Upload Form
Step2 . Approve
Option 2 :
Step 1. Client Upload Form
Step2 . Rejected
Step 3. Clent Upload Form again
Step 4. Approve
Option 3:
Step 1. Client Upload Form
Step2 . Rejected and they are uploading againg
Sample Data
FormID UplodadedDate Status
001 01/01/2019 Approved
002 01/01/2019 Rejected
003 01/01/2019 Approved
004 01/01/2019 Rejected
005 01/01/2019 Approved
006 01/01/2019 Approved
002 07/01/2019 Approved
009 01/01/2019 Rejected
Required Output
Should identify the forms that are rejected and not uploaded again
RawData:
NoConcatenate
Load * Inline [
FormID,UplodadedDate,Status
001,01/01/2019,Approved
002,01/01/2019,Rejected
003,01/01/2019,Approved
004,01/01/2019,Rejected
005,01/01/2019,Approved
006,01/01/2019,Approved
002,07/01/2019,Approved
009,01/01/2019,Rejected
];
Approved:
load Distinct
FormID as [FormID Approved]
Resident RawData
Where Status='Approved';
Rejected:
NoConcatenate
Load *
Resident RawData
Where not Exists([FormID Approved],FormID);
Drop Table RawData;
Drop Table Approved;