space at end of field

[flo2]

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

[marcus_sommer · Accepted solution]

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]

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