provider_id
, from the source t0
Medicare Outpatient Charges table with records from the t1
Medicare Inpatient Charges table, we create a comparison that joins records when table's provider_id
s are equal.t1
, the variables in that table will be available to keep in the output table or discard using the variable selector interface, prefixed with a t1
tag. You can also access these variables when filtering rows, creating new variables, etc.