Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

macaulay
Contributor

Usage of Excel table:different columns with same content

Hi together,

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

Zeit.JPG

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:

ProjektZeit
16-0000016:00
16-0000027:00
16-0000034: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

1 Solution

Accepted Solutions
martinpohl
Valued Contributor II

Re: Usage of Excel table:different columns with same content

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

5 Replies
martinpohl
Valued Contributor II

Re: Usage of Excel table:different columns with same content

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
Esteemed Contributor

Re: Usage of Excel table:different columns with same content

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?

macaulay
Contributor

Re: Usage of Excel table:different columns with same content

That's how it works, thank you!

macaulay
Contributor

Re: Usage of Excel table:different columns with same content

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

serefkeser
New Contributor

Re: Usage of Excel table:different columns with same content

Good.