Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Partner - Master
Partner - Master

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

View solution in original post

5 Replies
martinpohl
Partner - Master
Partner - Master

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
Not applicable
Author

That's how it works, thank you!

Anonymous
Not applicable
Author

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

serefkeser
Contributor
Contributor

Good.