Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

Load excel file

Bonjour,

I would like to know how I can consider the first column of my excel file as field titles.

LOAD F1,

     [Relation 1],

     [Relation 2],

     [Relation 3],

     [Relation 4],

     [Relation 5],

     [Relation 6],

     [Relation 7],

     [Relation 8],

     [Relation 9],

     [Relation 10],

     [Relation 11],

     [Relation 12],

     [Relation 13],

     [Relation 14],

     [Relation 15],

     [Relation 16],

     [Relation 17]

From Exemple;

je fais ca :

Projet

Détails du projet

Si autre projet ou sujet, précisez

Acteur

Si nécessaire, précisez

Type d'acteur

Service / Direction en relation l'ASIP Santé

Service / Direction en relation avec l'acteur

Collaborateur(s)  en relation

Thank you

Maurice

Ci-joint le Screenshots !

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Maybe transpose your table:

Aufnahme_2017_10_04_15_16_16_792.gif

View solution in original post

3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Maurice,

Use the crosstable statement for this:

Crosstable ‒ QlikView

This will get you a table with the first line as fields on a table, so it will transpose your table in a way.

Felipe.

Frank_Hartmann
Master II
Master II

Maybe transpose your table:

Aufnahme_2017_10_04_15_16_16_792.gif