I have pulled in a dataset which has the employee login which should be 6 numerics. However, the data includes some nonnumeric characters (maybe contractors?) and so the column is STRING and not INTEGER.
If I convert the column using INT(<column>) it will fail.
I couldnt find a function to test for Numerics... or maybe I am looking in the wrong place. But I need to filter out these non numerics rows in DataMeer so I can join it onto another sheet which has the join field as numeric.
Please sign in to leave a comment.