Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have one column to load, and every third line contains the same type of data:
i.e.
Firstname1
Name1
City1
Firstname2
Name2
City2
Firstname3
Name3
City3
...
As said, the structure of the lines in the one and only column of my source (Excel) are always the same.
What I would like to have is a table in QlikView to show the values like this:
Firstname Name City
-----------------------------------------
Firstname1 Name1 City1
Firstname2 Name2 City2
Firstname3 Name3 City3
...
Thanks for any idea!
A generic load could do the trick. See attached example.
A generic load could do the trick. See attached example.
Many thanks, Gysbert!
Very helpful. Great idea!
Best Regards
Frank