Expand my Community achievements bar.

SOLVED

Split column based on whether the field contains non numeric values

Avatar

Level 2

Hi,

 

I'm working on an import workflow, the data I'm receiving isn't clean. I need to map a string field into a long field. However the source RDBMS field contains values that has non numeric. I'm trying to manage this with either a split or a test but I'm getting nowhere as ISNAN(fieldname) isn't supported (apparently).

 

Does anyone know how to work with this?

1 Accepted Solution

Avatar

Correct answer by
Level 10

use something Query: stringFieldName not like '%[^0-9.]%'

 

if you use this query you can filter the values in the split.

 

Note: This is only tested with Postgres as the underlying database. 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

use something Query: stringFieldName not like '%[^0-9.]%'

 

if you use this query you can filter the values in the split.

 

Note: This is only tested with Postgres as the underlying database. 

Avatar

Level 2

I was unable to fix this permanently, I was forced to query the RDBMS for values not containing ":" for example. This is a mere bandaid for what I was trying to achieve but at least we can run BAU import again.