Round numbers in mixed column

[zzinoun]

Hello,

I have a specific request to round up numbers in mixed column (Text + Numbers)

Do you have an idea how I can proceed ?

Thank you,

[truptis · Accepted solution]

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 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.