Solved

Is there a way to set Multiple Columns into One Column?

  • 5 March 2021
  • 2 replies
  • 19 views

Userlevel 4
  • Gainsight Employee: Shoshin
  • 2 replies

Hello 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!  

icon

Best answer by rakesh 9 March 2021, 04:03

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.

View original

2 replies

Userlevel 7
Badge

@iteku From your example, it looks like you’re trying to transpose a row into a column? Where would you be trying to do this? Just visually? Or are you trying to move data around?

 

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.

Userlevel 7

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.

Reply