Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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