file csv whitout first line

[jmialoundama]

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

[Anil_Babu_Samineni]

This is possible while loading.

[jmialoundama]

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

[christophebrault · Accepted solution]

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/ScriptRegularStateme...

[gmoreau]

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.