Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear values visitors,
I got an issue with (.dat) file. For each file store like this:
{1=A 2=B 3=C}{1=X 2=Y
3=Z}{1=N 4=M 5=O}{1=K 6=P 10=R}
This is mean that one record seperate by {} and have no specific enter line.
So the result after QlikView read is like below:
1=A 2=B 3=C
1=X 2=Y 3=Z
1=N 4=M 5=O
1=K 6=P 10=R
How can I achieve this?
Very much appreciate for your idea.
Enclosure: DATA.dat (Open with Notepad to see content)
Regards,
Sokkorn
Hi Sokkorn,
Yes, my solution of looping over data might not be the best for large datasets!! I did find later that the second table load (DataRows) was not needed to force the row order. Taking that out and changing the original table name to DataRows would make it run faster.
flipside
Here's a slightly different approach to collapsing the "generic" tables. With the current data I can't measure a LOAD time but included the calculation in the QVW for use when it's run against the entire dataset.
Hi Ralf,
Many thanks for your solution. It working fine.
Copy: Dave: I try your file with 3 million records and it spend around 3 minute. Actually I have data more than billion records. By the way your solution is good for me to get new idea.
Thanks once again to all of you. You are my best friend .
Sharing culture!!!!
Cheer!!!!!!
Sokkorn