+4Hello Team,
We have a customer who reached out to if Is there a way to set Multiple Columns into One Column?
Below screenshot of the use case: Like, the records from A,B,C,D,E,F onto one column ‘H’
As of now I do not see any option as such we have and hence creating a post, if the above use case can be considered as an enchantment request!
Best answer by rakesh
Hi,
There is one way, which is to use multiple actions to load the data into the same field. Assume you have the data as shown in excel at the output of a rule,
Use 6 actions, in the first action map column A ( 1, A, Lily) to the Output column in the object. 2nd action for B and so on.
+8
Generally, how MDA data is stored each row is an individual record stored in an object, and each column is a field on an object.
If you try and transpose a row into a column, what you are saying, is you want the record ID to become a field on an object, and the values of the fields for the original record superimposed on a new column (field) you’ve created on all the records in the object.
I have a feeling that’s not what you’re looking to do, but maybe some additional information would be helpful to understand what you’re trying to do.
+2Hi,
There is one way, which is to use multiple actions to load the data into the same field. Assume you have the data as shown in excel at the output of a rule,
Use 6 actions, in the first action map column A ( 1, A, Lily) to the Output column in the object. 2nd action for B and so on.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
