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
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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: 
SheetalB
Contributor
Contributor
‎2022-05-24 03:55 AM

How to split 1 column value into 2 columns

Hi,

I need help in column splitting, please find test cast

I am getting below table data

Sr. No Reasons
1 Reason1
2 Reason2

 

I want output as below

1st Reasons 2nd Reasons
Reason1 Reason2

 

Thanks,

Sheetal

Labels (1)
Labels
486 Views
0 Likes
1 Reply
here2h3lp
Partner - Contributor III
Partner - Contributor III
‎2022-05-24 09:17 AM

Try the function CROSSTABLE

460 Views
0 Likes