Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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