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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jw22
Contributor III
Contributor III

Transform values from row into column

Hello,

I have following table in Qlik Sense:

jw22_0-1702467862561.png

But I want the data to be transformed and  to look in a table like that:

jw22_1-1702468010992.png

 

Can someone help me?

Thank you!

Labels (1)
2 Solutions

Accepted Solutions
Or
MVP
MVP

Parthiban
Creator
Creator

Hi,

Try this one

Generic
Load * inline [
ID, field, Value
28979, Maschine, 110163
28979, Werkzeug, w11606
];

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

2 Replies
Or
MVP
MVP

Parthiban
Creator
Creator

Hi,

Try this one

Generic
Load * inline [
ID, field, Value
28979, Maschine, 110163
28979, Werkzeug, w11606
];

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!