Multi-Picklist values into separate line items in MDA table
None
Don't know if this is more of a question or an idea, but putting this out there as I don't know if this is possible in Gainsight already.
I have a multi-picklist field for selection of product names that can have a variety of combined selections.
I want to try and capture those values as multiple rows in a single column, and write out to an MDA table. (for any Linux geeks, kind of like you can do with an AWK statement in a shell script)
Anyone know if this is already possible in Gainsight?
If not, then would be great if it could accomodate such a use case.
I have a multi-picklist field for selection of product names that can have a variety of combined selections.
I want to try and capture those values as multiple rows in a single column, and write out to an MDA table. (for any Linux geeks, kind of like you can do with an AWK statement in a shell script)
Anyone know if this is already possible in Gainsight?
If not, then would be great if it could accomodate such a use case.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Mapping of Multi-Picklist to string is possible via rules. This might help in solving your use case. Can you provide more details about the use case(example if possible), so that we can explore more.
We have 3 multi-picklist fields, each with 10-15 options to choose from. This results in somewhere around 256 different possible combinations that can be chosen. Without the ability to parse out the multi-picklist values into separate lines, I would have to write @256 rules in order to account for all the possible combinations.
Instead, our Salesforce team is looking into building a custom object for us with a trigger script to parse it out and store in SF. But this really takes a core chunk of the processes we're trying to build out of Gainsight's control.
The ‘Survey User Answer’ object has one record per option selected by a respondent.
There is a way to do this now via Data Designer.
Note: I completely agree that there should be a more elegant integration/solution that should be made available.
Thanks to@manu_mittal for suggesting the solution above.
Hi, I have tried this solution and the concatenate does not appear to work if I just use the space bar in the Default for the CASE. But works fine if I use a comma as the default. Is there anyway to enter just a space