How would do this in Tableau?
left join Sheet11 on Sheet11.id = Sheet1.id) B
on A.id = B.id
You bring first SummarySheet in your data prep window then you bring sheet1 then sheet11.
You specify the field id between SummarySheet and sheet1 on a left join.
You specify the field id between Sheet11 and Sheet1
Retrieving data ...