topic Re: file csv whitout first line in Francophones

file csv whitout first line

jmialoundama — Thu, 30 Aug 2018 13:35:06 GMT

HELLO,

I have a CSV file without a header and delimiter.

I would like to specify in QLIK SENSE that the first data is not the title of the column and put a title to that column.

Is it possible to do this in the Qlik Sense script? Here is my CSV file:

2051772_01.jpg

2051772_02.jpg

2051772_03.jpg

2051772_04.jpg

Thanks in advance

Re: file csv whitout first line

Anil_Babu_Samineni — Thu, 30 Aug 2018 13:45:48 GMT

This is possible while loading.

Re: file csv whitout first line

jmialoundama — Thu, 30 Aug 2018 13:51:44 GMT

Hello Anil ,

Thanks you for your answer.

I know it's possible in load script. But i would like to know what is the syntax for insert a label in CSV column in Qlik Sense.

I try this the option "NO LABELS" in load script :

ARTICLES:

load *

from [ARTICLES.QVD](qvd)

LEFT JOIN (ARTICLES)

LOAD

FROM [HTTP://media.com/jpg/liste.csv]

(txt, utf8, no labels ,delimiter is '\t', msq);

;

And the name of column is "@1" but i want rename the colonne.

I would like to know what is the option for insert a label

Re: file csv whitout first line

christophebrault — Thu, 30 Aug 2018 14:50:06 GMT

You can rename field in two way :

with a mapping table using : rename fields MapTableName

or manually with : rename fields @1 to FIeldName1,@2 to FieldName2, etc.

But you need to rename and then do you left join to make it work properly

https://help.qlik.com/fr-FR/sense/February2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/rename-field.htm

Re: file csv whitout first line

gmoreau — Thu, 30 Aug 2018 15:48:12 GMT

Bonjour,

essai qqlchose comme :

ARTICLES:

load *

from [ARTICLES.QVD](qvd)

LEFT JOIN (ARTICLES)

LOAD

@1 as Champs1,

@2 as Champs2,

......

FROM [HTTP://media.com/jpg/liste.csv]

(txt, utf8, no labels ,delimiter is '\t', msq);

Note: pour la jointure, il faut au moins un nom de champs commun entre les deux tables, sinon il y aura un produit cartesien.