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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BI_Rockstar_265
Contributor II
Contributor II
‎2021-06-07 05:59 AM

Convert one column rows having text (separated by comma) into multiple columns and it should equally distributed to column rows having values

Convert one column rows having text (separated by comma) into multiple columns and it should equally distributed to column rows having values

1,114 Views
0 Likes
2 Replies
Jayavignesh
Contributor III
Contributor III
‎2021-06-07 06:56 AM

You can use sub field function to split the row value with a delimeter (comma) - https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF... 

If you want to convert row to column, use Generic load.

1,070 Views
0 Likes
BI_Rockstar_265
Contributor II
Contributor II
‎2021-06-07 08:49 AM
Author

Hi, 

I have tried subfield function and i need this output table .

BI_Rockstar_265_0-1623070136114.png

 

1,045 Views
0 Likes