Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sbxr80
Contributor
Contributor

convert row data to coloumn wise

Hi

I am getting an output like below.

069U10000011kmdIAA.png

expected:

069U10000011a94IAA.png

please help me out

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello

Here is a scenario shows you how to achieve it.

 

069U10000014n81IAA.png069U10000014mf0IAA.png 

Code on tJavaRow:

output_row.line=input_row.id1+","+input_row.name1+";"+input_row.id2+","+input_row.name2+";"+input_row.id3+","+input_row.name3;

 

069U10000014n9dIAA.png069U10000014nBFIAY.png 

Hope it helps you.

 

Regards

Shong

View solution in original post

2 Replies
Anonymous
Not applicable

Hello

Here is a scenario shows you how to achieve it.

 

069U10000014n81IAA.png069U10000014mf0IAA.png 

Code on tJavaRow:

output_row.line=input_row.id1+","+input_row.name1+";"+input_row.id2+","+input_row.name2+";"+input_row.id3+","+input_row.name3;

 

069U10000014n9dIAA.png069U10000014nBFIAY.png 

Hope it helps you.

 

Regards

Shong

Sbxr80
Contributor
Contributor
Author

Thank you @Shicong Hong​