topic Re: Load excel file in QlikView

Load excel file

MauriceLudo — Wed, 04 Oct 2017 12:55:33 GMT

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 !

Re: Load excel file

felipedl — Wed, 04 Oct 2017 13:03:47 GMT

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.

Re: Load excel file

Frank_Hartmann — Wed, 04 Oct 2017 13:17:46 GMT

Maybe transpose your table:

Re: Load excel file

MauriceLudo — Wed, 04 Oct 2017 14:12:01 GMT

https://community.qlik.com/message/1350772?et=watches.email.thread#1350772