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 GA: Multivariate Time Series in Qlik Predict: Get Details
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: 
Not applicable
‎2012-08-13 04:22 PM

Splitting field values

I am loading a excel file (extracted from our CRM) where the fields having multiple choice reside in the same field. See below (the last three listings)

EC Printer
EC Printer
EC PathView
EC Fax
EC Overnight,EC PathView
EC Fax,EC Overnight
EC Fax,EC Overnight

Using the last entry, EC Fax and EC Overnight need to be two unique values and no combined. How can I split these values out to correctly display the fields?

Needs to be:

EC Printer
EC Printer
EC PathView
EC Fax
EC Overnight
EC Fax
EC Fax
EC PathView
EC Overnight
EC Overnight
466 Views
0 Likes
1 Reply
Not applicable
‎2012-08-13 04:39 PM
Author

See attached for an example. Note that there the strings are not separated by, but by | (to be able to load from inline)

This topic is helpful btw: http://community.qlik.com/thread/16564

split.qvw
245 Views