Split column based on whether the field contains non numeric values

Avatar

Avatar

domintune

Avatar

domintune

domintune

16-01-2020

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?

View Entire Topic

Avatar

Avatar

domintune

Avatar

domintune

domintune

29-01-2020

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.