Forum Discussion
Resolver IRound numbers in mixed column
Hi zzinoun ,
Firstly, create a new flag column and check if it is a number or a text. You can use something like this :
Value.Is([Column],type text) -> For textValue.Is([Column], Int64.Type) -> For number
Step 2: create a conditional column - if that flag column is numeric value then you can round it else nozzinoun -> Please hit the thumbs up & mark it as a solution f this helps you. Thanks.
Community ChampionHi zzinoun ,
Firstly, create a new flag column and check if it is a number or a text. You can use something like this :
Value.Is([Column],type text) -> For text
Value.Is([Column], Int64.Type) -> For number
Step 2: create a conditional column - if that flag column is numeric value then you can round it else no
zzinoun -> Please hit the thumbs up & mark it as a solution f this helps you. Thanks.