Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Can you post your script?
[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);
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.