9 Replies Latest reply on Oct 18, 2018 6:00 AM by Sam Johnson

    Blending two excel tables with a hyper extract

    Sam Johnson

      I have two tables coming from an excel spreadsheet. The fist tab is MEMBER and contains member_id and member_name. The second tab is DOCTOR and contains Doctor_id and Doctor_name. The third is a hyperextract. Let's call it VISIT which contains Doctor_id and member_id and visit_date. I want to join the three tables. I am using blending, but it looks like I can only blend two tables at a time. I can drag doctor_name from DOCTOR and visit_date (if I blend DOCTOR and VISIT), but I cannot also drag member_name from MEMBER. Am I missing something?