Qlikview "Group By" alternative (High memory usage)
I would like to analyze textual data from log files using Qlikview. Here would be sample data:
ID, EventID, Message
1 aa Begining of message here....
2 aa ....middle of message there....
3 aa ....end of message there
4 bb Another message
5 cc And another message
and so on.
If i try to group by EventID and concatenate messages "Group By" memory spikes up and it's completely impossible to do that way for aproximately 2.5milj of records. I don't have DB as data source so I can't pefrom grouping there.
Are there any other way to achieve that without using Group By using Qlikview script?