Skip to main content

Hi Guys,

 

I need to create a below scenario in Tableau.

I have a table with a column say Product with x number of entries.

And another table with a column of SKU with y number entries.

I need to create a combination of each entry in Product with each entry in SKU.

If someone could help with the same!

 

Combination of data from tables without any matching column

1 answer
  1. Mar 3, 2020, 12:46 PM

    good morning

     

    this can be done with a join field like this  1=1

     

    open the join calculation and select Create join calcualtion

     

    good morning this can be done with a join field like this 1=1 open the join calculation and select Create join calcualtion and enter 1 in the box that opens it will join every record in the first file

     

    and enter 1 in the box that opens

     

    pastedImage_0.png

     

    it will join every record in the first file with each record in the second

     

    Jim

    If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

0/9000