-
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…