1 Reply Latest reply on Aug 30, 2016 12:13 AM by Ben Whitaker

    Unique IDs in sheet 1 and Unique ID in sheet 2 question

    Michael Tom

      Hi All,

       

      I have 2 sheets that I need to join and can't find a solution to this problem.

       

      Sheet 1 has two unique IDs and Sheet 2 has one Unique ID.

      **I need to create a relationship to pull data from sheet 2 if either of the two IDs match in sheet 1.

       

      I tried left join however, I can only pull in Cad ID 1 in sheet 1 = AMA ID 1 in sheet 2.  If I include a second filter in the data source it shows an error. How do I get around this?

      IDs.png