Usage of Excel table:different columns with same content

[Anonymous]

Hi together,

I've got a little issue with an excel-sheet, I created for the usage in QLIK. The sheet looks like this:

As it can be seen, I have several columns, that contain the same content: Projekt and Zeit.

In fact the table could look like this also:

Projekt	Zeit
16-000001	6:00
16-000002	7:00
16-000003	4:00
......	...........

As it is easier for me to design the excel sheet like seen above, I would really like to keep it like it is. Is it possible to integrate this form of sheet in QLIK, so that I could tell QLIK f.e. to create the field "Projekt" as a list of all seen six columns of Projekt and elsewhise with "Zeit"?

Thanks for the replies and best regards,

Tom Müller

[martinpohl · Accepted solution]

Hello Tom,

load the datas without embedded labels (you get F1,F2,F3 (or similar with xlsx) and so on).

Then rename them to Project and Zeit.

But you have to load column by column.

load

F1 as Project,

F2 as Zeit

from xlsx;

load

F3 as Project,

F4 as Zeit

from xlsx

Regards

[OmarBenSalem]

U've created a table within qlik with dimensions : Projekt and Zeit and have remarked that Qlik has combined the duplicated rows into one?

Is this ur problem?

[Anonymous]

That's how it works, thank you!

[Anonymous]

I made the mistake to rename them in one LOAD section, I got an error. With the hint of Martin it works.

[serefkeser]

Good.