Hey HLIN, According do Domo documentation, Federated Datasets do not support Magic ETL. I've also just confirmed in my own instance that we are not able to use federated datasets as inputs in SQL transforms either: As for actually getting your data together, you would need to shift your focus to joining them outside of…

Hey Jason, A few things I would confirm: Do your input dataset contain the data and structure you are expecting? Can you spot check a few values that you would expect to see in the join and make sure the key matches in both datasets? Is your filter tile doing what you think it is? Do you see your target rows if you remove…

Thanks Zoolander. That function takes a text input. What do I enter for the value?