Forum Discussion
Helper IMore efficient way to keep only numbers in multiple columns
the first thing that comes to mind is to merge all the columns through a character not present in the texts (#, for example) apply your rules to the union columns and then redo the division of the colonan through the added separator (# , in the example)
Helper IThanks Jimmy - it's an interesting approach. Is there a simple way to contraint it specific columns? Unfortunately in my big data set in about 40 columns I need to keep the text and in aboout 110 I need to keep only the numerals.
Community ChampionHello k1s1
as I wrote in my post with my approach it's not needed to define the transformation of every column, but can do within one code as I'm referecing in my post as well. The idea is to get through every row... transform every single row to a table, transform the value-column and transform it back to a row... and then transform it to a table. The nice here is that you don't need to define every single column and therefore is dynamic.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy