Best Of
Re: How to Unpivot or Explode Variable-Length Lists in Domo to Flatten a Table?
There isn't really an explode option (csv column → rows) within Magic ETL. You can leverage a MySQL dataflow to help normalize the data. Code like may help you do this.
Re: How to Unpivot or Explode Variable-Length Lists in Domo to Flatten a Table?
You can do that with SQL as suggested or with Magic ETL (somehow I always end up visiting @MarkSnodgrass video on how to build a Word Cloud whenever it comes to a request like this), the logic would remain the same, you just change what the delimiter is that you're splitting by (and might want to add a trim after splitting or a replace for all blank spaces so POs are more or less clean).
Re: Ability to remove unnecessary columns directly in the input DataSet before loading all its rows
I totally agree,
having the possibility to drop some columns before processing
sometime could save a lot of execution time.
that's a must-have feature!
Re: August 2023 Community Forum Highlights
Congratulations everyone! Thanks for making this an awesome community.

