adspace


What are the differences between row-by-row select and cached comparison table and sorted input in table comparison transform?

Answer Posted / Rohit Pant

In Tableau, these three options can be used for comparing two tables. Here are their main differences:

1. Row-by-row Select - This option allows you to define a custom SQL query or calculation to compare rows directly. It does not use any caching or pre-sorting of the data.
2. Cached Comparison Table - This approach involves creating a temporary table that stores the comparison results, which can improve performance for large datasets. The temporary table is stored in memory, and its size is limited by your system's available resources.
3. Sorted Input - In this method, both input tables are sorted on the join key before comparing them. This allows Tableau to use efficient join algorithms, but it may require more computational resources for sorting large datasets.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Have you ever encountered the scenario of a chasm trap? If yes, what is the way to resolve it as per your suggestion? : sap bobi

995


What made you choose webi over other reporting tools?

1000