Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with loading a multiplie lines field

Hello Members,

I habe Problems with a field that sometimes stretches accross serveral lines.

Example:

headline name ! address ! phone ! comment

line 1 1111 ! short ! 3333 ! 4444

line 2 1111 ! really, really, really, really,really, really, really, really,

line 3 loooooooooooooooooooooooooooooooooooooong

line 4 ! 3333 ! 4444

Although I use "!" as Delimiter, Qlikview only stores the really-part into the address field and interprets the long-part as new name.

It is possible, to force Qlikview to ignore the end of line and continue filling fields?

5 Replies
martin59
Specialist II
Specialist II

Hello,

Could you send a part of your file to test ? You have several options when you load a table file like your delimiter, end of file option...

Martin

Not applicable
Author

Edit: I'll upload a sample of the table. It got messed up in the first try.

martin59
Specialist II
Specialist II

Thanks, I'm trying to load it 😉

martin59
Specialist II
Specialist II

Is it what you want ?

Not applicable
Author

Yes, that was what I needed. Thank you!