Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Transpose a Comma Separated Field

 

I have a field with comma separated numbers that I just need to turn into a column of single numbers - How to transpose in the script?

eg  Field of UserIDs

12345,23456
34567,45678,56789,67890,54321
82736
65432,11223,22334

 

Would become field with the following:-

12345

23456

34567

45678

56789

67890

54321

82736

65432

11223

22334

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

 

Got it...

SubField(UserID,',')

View solution in original post

1 Reply
Highlighted
Creator III
Creator III

 

Got it...

SubField(UserID,',')

View solution in original post