Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sokkorn
Master
Master

Cannot read text file.

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

12 Replies
flipside
Partner - Specialist II
Partner - Specialist II

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

Not applicable

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.

Sokkorn
Master
Master
Author

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