Locating conversions errors

[Hamder83]

Hi 

I often load several excel files into one big file. And because some of the input material is created manually, there is a difference in field types, using dot or comma. And many other issues.

So if I blend loads of files i get different conversions errors.

But either I just dont know how to do it correctly, but identifying which lines is the issue?

Ive created a sample issue:

Is there any easy way to filter out lines with conversion errors?


Thanks in advance, 

[Luke_C · Accepted solution]

Hi @Hamder83 , if order number is expected to be numeric, you could put a filter before the select tool throwing these errors that is isinteger([order_number])

That will check if the the value can be converted to a number, although typically I see order numbers stored as text values for this exact reason. 

[mceleavey]

@Hamder83 ,

this is because you're trying to apply a numeric format (fixed decimal) to a non-numeric field.

To isolate the rows where non-numeric figures occur, use regex and a filter:

Workflow attached.

I hope this helps,

M.

[Hamder83]

h of your ideas worked, so thank you very much. Luke will get the credit simply because he replied the fastest 🙂