Is it possible to add a leading zero to a field if it has a specific number of digits....problem I'm having is I have a field "routing number" which for the records that have 9 digits it displays all the numbers but the ones which have 8 digits it removes the leading zero.
Is your column a number instead of a string? It sounds to me like it's a number and they always drop leading zeros.
Can you bring the column in as a string instead? It's probably best to do that before Domo gets it for the first time. If you can convert the data type upfront, I think that's your best bet.
In case that's not an option, you can do some beast modes to get what you want.
Turn the number into a string and do some conditional logic by finding the string length, and if it's 8 characters, then concatenate a zero on to the front.
WHEN LENGTH(CONCAT('',`column`)) = 8
You set the column type to text within a Domo dataflow? That will just take a digit of zero and turn it into a character of 0, not add zeros. Were you able to try fixing the datatype outside of Domo first?
You can use LPAD() in a data flow.
You can use this with text or value fields.
I was just about to suggest LPAD. Solving it on the data source side is the best solution, but LPAD is what I used most often. But we always use SQL dataflows, and it sounds like you might be using the Magic ETL version, which doesn't have that function that I'm aware.