Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasiliy_Beshentsev
Creator III
Creator III

Count of symbols in one field?

Hello, everyone today!

I have a problem with loadind log file.

So first of all i have a big log file, about 4 mb.

It's got more than 16000 rows in.

2017-01-23 14_47_27-Qlik Sense Desktop.png

I'm loadind data like this, 16000+ rows in one field.

2017-01-23 14_54_47-Qlik Sense Desktop.png

I'm already write handler for this 1 row.

So here is my question: WHY QLIK SENSE CUTTING MY FILE?!

It's not full load of my file! I'm write that 1 record is 16000+ lines but after loadind it's NOT!

How i get the point? Take a closer look.

My last record after working handle is

2017-01-23 15_01_12-Qlik Sense Desktop.png

Let's take a look where is this record in file in NOTEPAD:

2017-01-23 15_03_36-.png

Why it's not full load of file?

12 Replies
Vasiliy_Beshentsev
Creator III
Creator III
Author

Thanks for help, your thoughts help me to write correct code!

Vasiliy_Beshentsev
Creator III
Creator III
Author

Thanks for help, your thoughts help me to write correct code!

Vasiliy_Beshentsev
Creator III
Creator III
Author

Thanks again, folks!

The right solution is:

2017-01-24 15_01_23-Qlik Sense Desktop.png