How to combine federated dataSet to another dataset?

I tried to combine 2 datasets using ETL but then realized that Federated dataset does not support ETL. So is there any other method to combine 2 datasets on this case?

Thank you,

Answers

  • @Quyen

    Try creating a View on top of the federated query and join the excel / file upload there in the view.

    A federated query can not be brought to Magic ETL but for a snowflake, we can have a view ( I think it's still BETA) but it should work.


    Thanks

    'Happy to Help'