topic Identify duplicate records upto Previous quarter in QlikView

Identify duplicate records upto Previous quarter

santhana — Thu, 16 May 2019 12:47:59 GMT

Hello Friends

I have attached data where I need to identify Mobile numbers as Repeat if they were available upto end of previous quarter.

Example: if mobile no of May is also available before 31st March (upto last Quarter) then it is repeat. Else fresh.

Raw sheet is the data and Output sheet is the required result

Re: Identify duplicate records upto Previous quarter

sunny_talwar — Mon, 20 May 2019 11:15:55 GMT

Is this needed to be done in the script? If yes, then try this

Table: LOAD *, Date#(Month&'-'&Year, 'MMM-YYYY') as MonthYear; LOAD Mob_No, Month, Year FROM [..\..\Downloads\Sample_Test.xlsx] (ooxml, embedded labels, table is Raw); FinalTable: LOAD *, If(Mob_No = Previous(Mob_No), 'Repeat', 'Fresh') as Result Resident Table Order By Mob_No, MonthYear; DROP Table Table;