Bengaluru, IN

Welcome to the Bengaluru User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

Need help in shifting the data from one column to another column.

8 - Asteroid

Hi all,


Please help me out on how can I shift the highlited data from one column to another. Like this they are randomly distributed in these two columns.


Kindly please help me out how to place the data in their respective columns.


Thanks in advance.


Best Regards,

B. Sreenivasa Teja. 




8 - Asteroid

Please refer to this screenshotPlease refer to this screenshot.Please refer to this screenshot.

7 - Meteor

You can use the formula tool to solve this. Use the formula tool and write conditional (if-else statement)


1) If characteristics_crm contains number then characteristics value = characteristics_crm else retain the value of charecteristics_value

2) If characteristics_value contains string then characteristics_crm = characteristics_value else retain the value of charecteristics_value


Hope this helps.


If yes, then please give me a star to appreciate my time and efforts.

If not, then please upload a sample workflow with text input and your expected output (manually created) so that I can work on the same.