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: 
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
338 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
117 Views