Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try this
Table: LOAD Hash128(COMPANY&'|'&SUB_COMPANY&'|'®ION&'|'&YEAR) as Key, *; LOAD * INLINE [ COMPANY, SUB_COMPANY, REGION, YEAR, RANK ABC, AB, X, 2017, 3 ABC, AO, Y, 2014, 8 ABC, AO, X, 2016, 4 XYZ, AA, Q, 2015, 3 PQR, 21, X, 2015, LAST ]; MinMax: LOAD MinYear + IterNo() - 1 as YEAR While MinYear + IterNo() - 1 <= MaxYear; LOAD Min(YEAR) as MinYear, Max(YEAR) as MaxYear Resident Table; Left Join (MinMax) LOAD DISTINCT COMPANY, SUB_COMPANY, REGION Resident Table; Concatenate (Table) LOAD COMPANY, SUB_COMPANY, REGION, YEAR Resident MinMax Where not Exists(Key, Hash128(COMPANY&'|'&SUB_COMPANY&'|'®ION&'|'&YEAR)); DROP Table MinMax;
@sunny_talwar ..
Sunny Bhai .. Please help
Try this
Table: LOAD Hash128(COMPANY&'|'&SUB_COMPANY&'|'®ION&'|'&YEAR) as Key, *; LOAD * INLINE [ COMPANY, SUB_COMPANY, REGION, YEAR, RANK ABC, AB, X, 2017, 3 ABC, AO, Y, 2014, 8 ABC, AO, X, 2016, 4 XYZ, AA, Q, 2015, 3 PQR, 21, X, 2015, LAST ]; MinMax: LOAD MinYear + IterNo() - 1 as YEAR While MinYear + IterNo() - 1 <= MaxYear; LOAD Min(YEAR) as MinYear, Max(YEAR) as MaxYear Resident Table; Left Join (MinMax) LOAD DISTINCT COMPANY, SUB_COMPANY, REGION Resident Table; Concatenate (Table) LOAD COMPANY, SUB_COMPANY, REGION, YEAR Resident MinMax Where not Exists(Key, Hash128(COMPANY&'|'&SUB_COMPANY&'|'®ION&'|'&YEAR)); DROP Table MinMax;
Thank You Bhai