let
Source = Table.NestedJoin(Table1, {"REDCap ID"}, Table2, {"REDCap ID"}, "Table2", JoinKind.LeftOuter),
#"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"Column1", "Submitter Affiliation", "Point of Care affiliation", "If Other, please provide affiliation", "Submitter Full Name", "Name of Submitter", "Notification Date", "Notification Time", "Is this a:", "Was DC Health Notified through DGMQ / Epi-X?", "DGMQ ID / Epi-X ID", "Please select mode of travel where exposure could have occurred based on DGMQ notification", "Flight Number", "Cruise Name", "Passport Country", "Passport Number", "Key contact related to this person included in DGMQ ", "Date arrived in U.S.", "Last possible exposure date (Day 0)", "Date Monitoring by DC Health Started (may not be Date for Day 1)", "Monitoring end date (14 days after [exposure_end_dt] )", "How was DC health notified of the case?", "Caller/Provider FIRST name", "Caller/Provider LAST name", "Caller/Provider Phone Number", "Caller/Provider Email", "Caller/Provider Affiliation/Organization", "College/University/School Name:", "If other, please specify", "FIRST name", "LAST name", "MIDDLE Intial", "Date of birth (in the format of MM-DD-YYYY)", "Age (years)", "Patient sex", "Please describe other sex:", "Patient sex at birth", "Patient currently pregnant?", "How many weeks pregnant?", "Estimated due date"}, {"Column1", "Submitter Affiliation", "Point of Care affiliation", "If Other, please provide affiliation", "Submitter Full Name", "Name of Submitter", "Notification Date", "Notification Time", "Is this a:", "Was DC Health Notified through DGMQ / Epi-X?", "DGMQ ID / Epi-X ID", "Please select mode of travel where exposure could have occurred based on DGMQ no", "Flight Number", "Cruise Name", "Passport Country", "Passport Number", "Key contact related to this person included in DGMQ ", "Date arrived in U.S.", "Last possible exposure date (Day 0)", "Date Monitoring by DC Health Started (may not be Date for Day 1)", "Monitoring end date (14 days after [exposure_end_dt] ).1", "How was DC health notified of the case?.1", "Caller/Provider FIRST name.1", "Caller/Provider LAST name.1", "Caller/Provider Phone Number.1", "Caller/Provider Email.1", "Caller/Provider Affiliation/Organization.1", "College/University/School Name:.1", "If other, please specify.1", "FIRST name.1", "LAST name.1", "MIDDLE Intial.1", "Date of birth (in the format of MM-DD-YYYY).1", "Age (years).1", "Patient sex.1", "Please describe other sex:.1", "Patient sex at birth.1", "Patient currently pregnant?.1", "How many weeks pregnant?.1", "Estimated due date.1"})
in
#"Expanded Table2"