FIELD NAME PROBLEM

[pittouti]

Hello everybody,

on QLIK SENSE when doing an extract  csv using STORE function the column names are always like this:

queryname.fieldname

even if I rhyme the field using "AS" it will be:

queryname.Newfieldname

do you have a way around this problem?

because to do "concatenate" it does not hurt

Thx

[JustinDallas]

1. Are you reading your initial data into a table with a name? i.e

SomeTableName:
LOAD *
;
SQL SELECT...
;

vs.

LOAD *
;
SQL SELECT...
;

If you don't name the table, it will use whatever it's reading from.

[pittouti]

yes with a name

and even if I don't put a name, it is automatically put example: Data-1

But i don't use SQL select, Load* only

[JustinDallas]

Can you post your script?

[pittouti]

[Encours_HISTO]:
Load *

FROM [lib://IA1 - VSCBE Qlik Sense/Encours.csv];

concatenate
[Encours_HISTO]:
Load *,
weekname([Encours.TASRD]) AS Semaine,
if(([Encours.TASRD]<today()) AND ([Encours.TASRD]>today()-(13*7)),'Oui','Non') AS [13 SG ?],
if([Encours.MIDD]<today(),'OK','KO') AS [RDEI]
From Encours;

//
Store Encours_HISTO Into [lib://IA1 - VSCBE Qlik Sense/Encours.csv] (txt);

[JustinDallas]

Are the fields coming from Encours table of the form "Encours.Escargo"?  I'm asking because I see you doing a LOAD * below your concatenate, and that's going to bring in the fields as they are named in the table.