Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
Try this:
Table:
LOAD ACCOUNT,
ACTIVITY,
GROUP1,
GROUP2
FROM
[https://community.qlik.com/thread/218639]
(html, codepage is 1252, embedded labels, table is @1);
Link:
LOAD Distinct *;
LOAD *,
If(ACTIVITY = '2XX', 199 + IterNo(),
If(ACTIVITY = '3XX', 299 + IterNo(), ACTIVITY)) as ACTIVITY_LINK
Resident Table
While IterNo() <= 100;
DROP Table Table;
Left Join(Link)
LOAD ACCOUNT,
ACTIVITY as ACTIVITY_LINK,
AMOUNT
FROM
[https://community.qlik.com/thread/218639]
(html, codepage is 1252, embedded labels, table is @2);
FinalTable:
LOAD ACCOUNT,
ACTIVITY,
GROUP1,
GROUP2,
Max(AMOUNT) as AMOUNT
Resident Link
Group By ACCOUNT, ACTIVITY, GROUP1, GROUP2;
DROP Table Link;
Like this?
Table:
LOAD ACCOUNT,
ACTIVITY,
GROUP1,
GROUP2
FROM
[https://community.qlik.com/thread/218639]
(html, codepage is 1252, embedded labels, table is @1);
Link:
LOAD Distinct *;
LOAD *,
If(ACTIVITY = '2XX', 199 + IterNo(),
If(ACTIVITY = '3XX', 299 + IterNo(), ACTIVITY)) as ACTIVITY_LINK
Resident Table
While IterNo() <= 100;
DROP Table Table;
FACT:
Right Keep (Link)
LOAD ACCOUNT,
ACTIVITY as ACTIVITY_LINK,
AMOUNT
FROM
[https://community.qlik.com/thread/218639]
(html, codepage is 1252, embedded labels, table is @2);
Thank you Sunny T!
Is there any way to omit those values for example Rows 4/5/12/etc?
Because those are amounts that I not need.
Try this:
Table:
LOAD ACCOUNT,
ACTIVITY,
GROUP1,
GROUP2
FROM
[https://community.qlik.com/thread/218639]
(html, codepage is 1252, embedded labels, table is @1);
Link:
LOAD Distinct *;
LOAD *,
If(ACTIVITY = '2XX', 199 + IterNo(),
If(ACTIVITY = '3XX', 299 + IterNo(), ACTIVITY)) as ACTIVITY_LINK
Resident Table
While IterNo() <= 100;
DROP Table Table;
Left Join(Link)
LOAD ACCOUNT,
ACTIVITY as ACTIVITY_LINK,
AMOUNT
FROM
[https://community.qlik.com/thread/218639]
(html, codepage is 1252, embedded labels, table is @2);
FinalTable:
LOAD ACCOUNT,
ACTIVITY,
GROUP1,
GROUP2,
Max(AMOUNT) as AMOUNT
Resident Link
Group By ACCOUNT, ACTIVITY, GROUP1, GROUP2;
DROP Table Link;