user09445

This is what I did and it worked for transforming a column datatype from text to number as my original dataset could not be corrected I would have to do it in ETL workflow. Note that my original data even though was a text type it did not contain any text character but strictly number. It was just incorrectly recorded as…

this is super helpful! thanks for posting.

I even used Replace Text to replace any null or empty string with '0' before connecting to Text Formatting, making my dataset clean and reasy to read

that's right. That would be what I would like to achieve. Any solution?

continue this as example, how do I build further with this script as if to comma seperate customer states in one row, aggreated by customer name? I would assume the current script would only work for 1 customer name assigned to 1 uniue state vs multiple states. 

This is my script and it did not work instead gave me error message saying function groupby_concat did not exsit. SELECT `customers_id`, GROUPBY_CONCAT (`warehouse`) FROM `orders` GROUP BY `customers_id`;

can someone from Domo look into this function GROUPBY_CONCAT and fix it soon? There're people already mentioned that this function did not work using Mysql methiond in Workflow creatio process in the thread. How come this is not yet being solved as it's a critical SQL aggregation function? I also got the error message…