topic Re: field with space before text not found in QlikView

field with space before text not found

Antoine553 — Fri, 12 Mar 2021 10:38:05 GMT

Hello,

I'm working on a script to load all the files in a folder into a single table (same data in all files with same headers). However I have a problem with one of my filed wich start with a space.

When I try to load it like :

Load " IMMAT" as Immatriculation field2 as fieldblabla etc ...

I always get an error : field " IMMAT" not found.

I can't modify the header and delete the space since all the futures files will arrive with the same name so I'm stuck with it. Can someone explain why it is not accepting it and how to correct that pls ?

Re: field with space before text not found

eddie_wagt — Fri, 12 Mar 2021 13:01:37 GMT

Hello Antoine553,

I believe you can use this as load statement, because Qlik use automatically a trim on the fieldname.

LOAD

IMMAT as Immatriculation

etc...

Otherwise if fails, you can use before your load statement this

SET Verbatim = 1;

Did not test it though.

Re: field with space before text not found

MayilVahanan — Sat, 13 Mar 2021 03:09:44 GMT

Hi Antoine,

Might be one of the excel file doesn't have spaces in front.
For testing purpose, can you use

Load * from ursource;
And check how the field name (either with space or without space) or few file contains without spaces or not.
From that, you can proceed further.