Magic ETL -Combine Columns

Pau

Hello, I am trying to connect 2 columns from Snowflake Data Set nd I am using ETL "Combine Columns" function, but it's giving me an error - attached print screens. Any idea what's wrong? Thanks in advance

ETL2.PNG

ETL.PNG

MichelleH

@Pau It looks like you need to configure your output dataset (i.e. name it). Domo considers the dataflow to be incomplete if the output tile is not configured.

Pau

still having error "required DataSet does not exist" (see print screen). DataSet fur sure exists since I was able to choose it as input DataSet.

ETL3.PNG

akeating

If you click Change Dataset, do you still see that dataset listed as an option (even if it's greyed out)?

Pau

yes, I can see it

ETL4.PNG

akeating

Yikes...I wish I could offer more help!

My best suggestion is to contact Support unless someone else in the Dojo has seen this before and knows what's happening.

mhouston

@Pau you can't use a federated dataset in Magic ETL (see the KB https://domo-support.domo.com/s/article/360049429094?language=en_US). However I did see another thread where @MarkSnodgrass suggested using the dataset copy connector as a workaround: https://dojo.domo.com/main/discussion/53014/mitigating-v2-federated-source-limitation-in-magic-etl