Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
flo2
Contributor III
Contributor III

space at end of field

Hello,

I was wondering about something i can't resolve, the case when there is a space at the end of a field in source files.

In this case i always have to remove in excel the final space because when i try on Qlikview to have
"Name " ( so a space after the name of the field as on excel), it stills doesn't work, as if Qlikview didn't detect that i put a space so it is searching "Name".

I tried replacing the space by chr(32) but it still doesn't work...

If someone had already dealt with this, i would like to know how 😛

 

Thanks for reading

 

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe it's not a single space else multiple ones and/or also other chars like tab and line-breaks. If you used the table-wizard Qlik should provide a valid syntax - maybe something like:

load [Name
] as Name ...

and you could just take this and adding an appropriate as-statement like here shown in bold.

- Marcus

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Maybe it's not a single space else multiple ones and/or also other chars like tab and line-breaks. If you used the table-wizard Qlik should provide a valid syntax - maybe something like:

load [Name
] as Name ...

and you could just take this and adding an appropriate as-statement like here shown in bold.

- Marcus

flo2
Contributor III
Contributor III
Author

Thanks a lot , it was because it was not a character recognized indeed 🙂 !