In this silent video, you’ll learn how to use 'OR' in the join clause in Tableau Prep.
Read the full article here: Using 'OR' in Join Clause in Tableau Prep - [ Ссылка ]
- - - - - - - - - - - - - -
1. Connect to Sheet1 and to Sheet2
2. Join Sheet1 & Sheet2 by dragging Sheet 2 as a Join to Sheet 1. The inner join should show: Sheet1.A=Sheet2.A
3. Join Sheet1 & Sheet2 by by dragging Sheet 1 as a Join to Sheet 2. The inner join should show: Sheet1.B=Sheet2.B
4. To remove duplicated records, filter Join 2 by the calculation: NOT [A]=[A-1]
5. Union Join 1 & Join 2 by dragging Join 2 to Join 1 as a Union.
- - - - - - - - - - - - - -
Subscribe to the Tableau YouTube channel here: [ Ссылка ]
Free Trial of Tableau: link: [ Ссылка ]
Ещё видео!