We import data from Salesforce tables. Some of those tables include Multi Picklist values that come in as text strings separated by a ";"
eg: one record could have a field value 'value 1;value 2;value 4'. Another record could have the field value 'value 3;value 4;value 5'
I would like create a load script that will "explode" these multi picklist values into multiple fields inside my Qlik Table.
If my data in Salesforce looks like this:
| Case Record Id | Case Reason |
|---|
| Case 1 | Value 1;Value 2;Value 4 |
| Case 2 | Value 1;Value 3;Value 4 |
| Case 3 | Value 1;Value 2;Value 3;Value 5 |
I would like to get a table that looks like this:
| Case Record Id | Value 1 | Value 2 | Value 3 | Value 4 | Value 5 |
|---|
| Case 1 | 1 | 1 | 0 | 1 | 0 |
| Case 2 | 1 | 0 | 1 | 1 | 0 |
| Case 3 | 1 | 1 | 1 | 0 | 1 |
One thing i should say is that my list of possible values in my picklist is preset - i know what they are and therefore the structure of my final table is preset and does not need to be dynamic.
I have gone down the path of trying to run a For Next statement to parse the Case Reason string but i don't know how to include the results inside a load statement or how to update a resident table with the final details.
Any help veryvery appreciated
Helene
