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 😛
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.
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.
