Replacing Blank Values in Dataflow
I am creating an ETL dataflow in which I need to join my input dataset with other data sources via my column 'Sold-to Industry Code 1'. Although the values in 'Sold-to Industry Code 1' are numbers, Domo is treating it as text. This column is brought into Domo with blanks. I am trying to convert 'Sold-to Industry Code 1' to a whole number field via 'Set Column Type' to perform my join. It appears I cannot perform this action due to the blank values in 'Sold-to Industry Code 1' in some rows. I have attempted to replace my blank values via the 'Replace Text' funtion but to no avail. How do I both replace blank values in my column and convert the resulting column to a whole number?