Now, if your data source is a relational database such as Oracle, SQL Server, MySQL, or Snowflake that supports a Custom SQL Input step, then you could write your own SQL to perform UNION, INTERSECT or MINUS / EXCEPT unions in Tableau Prep.īut what if you are using a data source that doesn’t support the logic? Or you need to implement it somewhere in the flow other than the input?ĭon’t worry! Tableau Prep has you covered! It has all the foundational tools to allow you to implement all kinds of data shaping logic! UNION in Tableau Prep That is, if a record exists in both tables or only in the second, it is not retained in the resulting set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |