Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that looks like that:
PPR | INR | IVR_DATE |
---|---|---|
1 | 11 | 01/01/16 |
1 | 12 | 20/01/16 |
1 | 13 | 15/01/16 |
2 | 221 | 30/12/15 |
2 | 222 | 20/10/15 |
2 | 223 | 09/08/15 |
I need to add 2 columns to the table with the min and max IVR_DATE of the PPR.
How can i do it in the script when i'm loading the table?
Thx for help and sry for bad english
Try this:
Table:
LOAD PPR,
INR,
IVR_DATE
FROM
[https://community.qlik.com/thread/212990]
(html, codepage is 1252, embedded labels, table is @1);
Left Join (Table)
LOAD PPR,
Date(Min(IVR_DATE)) as MinDate,
Date(Max(IVR_DATE)) as MaxDate
Resident Table
Group By PPR;
Try this:
Table:
LOAD PPR,
INR,
IVR_DATE
FROM
[https://community.qlik.com/thread/212990]
(html, codepage is 1252, embedded labels, table is @1);
Left Join (Table)
LOAD PPR,
Date(Min(IVR_DATE)) as MinDate,
Date(Max(IVR_DATE)) as MaxDate
Resident Table
Group By PPR;
Use the same table and use Resident option calculate the Min & Max dates. Finally Join back to your main table.