Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
AlexGol
Contributor II
Contributor II

Cross Table into Straight Table

Hey Guys

Does anyone know how to turn a cross table into a straight table? What syntax to apply?

For example, I have one field with 8 values in a table and I need to cross-table this field in such a way so that those 8 values turn into 8 fields.

Visually like this:

from this 

a

b

c

into this

a     b     c 

 

Many thanks in advance

if you don't plan you plan to fail
1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @AlexGol ! 

        I think you can use a Generic Load.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

 

 

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @AlexGol ! 

        I think you can use a Generic Load.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

 

 

Help users find answers! Don't forget to mark a solution that worked for you!
AlexGol
Contributor II
Contributor II
Author

Hi Joaopaulo_delco!

Thank you for your prompt reply. I will give it a go to see if it helps and come back to you soon.

Thanks Alex

if you don't plan you plan to fail