Cast and Convert
Can I use Cast and Convert in dataflows? Is there something special I need to do?
Are there tables that have card information on them?
Are there any accessible tables in DOMO that have the information for cards on them? Something like below? Card NameURLDay CreatedABCDOMO.com/EFG2/16/2016
Checking a columns datatype
Does anyone know if there is a way to check a column's datatype? I've noticed sometimes if bad data gets uploaded to a datasource it can change the columns type (for example from an int to a string) and I wanted to write a query to catch that faster. Anyone have any ideas?
Changing a string to a number
Hi all, I have a column that has values like this '14%'. Domo is considering it a string, but I'd like it to number, preferably a decimal. I've been trying a few different SQL functions in Dataflows to chop off the percent sign (and then CAST it into a decimal), but the ones that would do the trick don't seem to be…