topic Re: Remove space from field name in QlikView

Remove space from field name

sanjujeeboy — Sat, 16 Nov 2024 02:09:42 GMT

i have a field like this in some excel files:

[Province

and in some excel i have field like this : [Province]

how to load all files at same time. Right now if i load , it throws error province field not found because of different formats.

Re: Remove space from field name

DavidM — Tue, 22 Oct 2019 10:50:17 GMT

You can load columns based on their order @1 if xls file, column letter eg. A if xxls. Like this:

LOAD
A as field1
B as field2

FROM [lib://*.xlsx]
(ooxml, no labels, header is 0 lines, table is [table])
;

Be sure to include no labels in the load.

Re: Remove space from field name

Brett_Bleess — Wed, 30 Oct 2019 21:14:59 GMT

Sanju, did David's suggestion work for you on this one? If so, be sure to come back and use the Accept as Solution Button to give him credit and let others know that worked. If you are still working on things, leave an update. I cannot think of any better way to go about things than what David described.

Regards,
Brett

Re: Remove space from field name

Surya — Thu, 31 Oct 2019 09:32:15 GMT

Hello.,

Before reload need to change field like this

mid(Province,2,10) as Province

do it in data model