Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Double Excel-header

Hi,

I've got a problem with my data source (Excelsheet). I cannot manage the table format into a straight QV design.

I tried to take the Name of the "User" instead of the header into each data row, until the next User (same Excelsheet) follows. Here is an example of what it looks like:

screenshot.png

In QV table it should look like this:

User1     Start     End     Type...

User1     Start     End     Type..

User1     Start     End     Type...

User2     Start     Ende     Typ...

Has anybody an idea? Thanks a lot!

Ingo

Community Browser