Magic ETL -Combine Columns

Pau

Pau Member

November 2022 edited March 2023 in Scheduled Reports

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

0

Comments

MichelleH Coach

November 2022

@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.

1
Pau Member

November 2022

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

0
akeating Contributor

November 2022 edited November 2022

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

**Was this post helpful? Click Agree, Like, or Awesome below.**
**Did this solve your problem? Accept it as a solution!**
0
Pau Member

November 2022

yes, I can see it
ETL4.PNG

0
akeating Contributor

November 2022

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.

**Was this post helpful? Click Agree, Like, or Awesome below.**
**Did this solve your problem? Accept it as a solution!**
0
mhouston Contributor

November 2022

@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

1

Categories