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