Skip to main content

Qlik

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 Introduces a New Era of Visualization! READ ALL ABOUT IT
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

681 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.

637 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

 

612 Views
0 Likes