Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am new to Qlikview and I need help extracting only max values corresponding to OriginalICERecordID(ReadyPublish) in ICERecordID(ReadyPublish) keeping all the other columns and delete the rows which do not contains max value. Length of these field is 15 char. This data is getting imported from a CSV file.
This is 1 example, file contain thousand of such entries.
Thanks and regards
Abhijit
Can you try MaxString instead of Max
Right join (Omega)
Load [OriginalICERecordID(ReadyPublish)],
MaxString([ICERecordID(ReadyPublish)]) as [ICERecordID(ReadyPublish)]
Resident Omega
Group by [OriginalICERecordID(ReadyPublish)];
May be do a right join like this
Right Join (FactTable)
LOAD [OriginalICERecordID(ReadyPublish)],
Max([ICERecordID(ReadyPublish)]) as [ICERecordID(ReadyPublish)]
Resident FactTable
Group By [OriginalICERecordID(ReadyPublish)];
Get the max value in one table and then do a right join with original one.
It will give the desired result.
If you can share sample data, it would help
Hi stalwar1
Thank you for reply, however after executing this code, I am getting the following output.
Regards
Abhijit
Can you post the exact script you tried?
Table:
LOAD *
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Right join (Table)
Load (OriginalRecID),
Max(RecID) as RecID
Resident Table
Group by OriginalRecID;
Can you try MaxString instead of Max
Right join (Omega)
Load [OriginalICERecordID(ReadyPublish)],
MaxString([ICERecordID(ReadyPublish)]) as [ICERecordID(ReadyPublish)]
Resident Omega
Group by [OriginalICERecordID(ReadyPublish)];