8 Replies Latest reply on Nov 28, 2018 11:06 PM by Hari Ankem

    Joining 2 EXCEL Sheets together with no common fields

    Matthew Mensch

      Hello,

       

      I am using Tableau 10.2.5.

       

      I have a scenario where I have 2 sheets inside the excel workbook:

      1. Sheet 1 contains 2 fields: Model ID and Customer.
      2. Sheet 2 contains 1 field: Binned Levels

       

      I need a way to add the binned levels to each model id/customer. They have nothing to join on. Is there an easy way to do this?

       

      Sorry in advance if this is a trivial question.

       

      What I am looking for is:

      Model ID | Customer  | Binned Level

      -----------------------------------------------------------------

      1              | A               | 0.92

      1              | A               | 0.9201

      1              | A               | 0.9202

      1              | A               | 0.9203

      1              | A               | 0.9204