Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
macaulay
Creator
Creator

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
Partner

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
Partner

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

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
Creator
Creator
Author

That's how it works, thank you!

macaulay
Creator
Creator
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.