Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
dominic_marchan
Contributor III
Contributor III

Create new table based on two resident tables (loop)

Hi all,

 

I have two tables, one with date and the other with model number. I would like to create a third table that has every dates for every model number

Dates
1/1/2019
1/2/2019
1/3/2019
...

 

Model
A
B
C

 

Final table 
DateModel
1/1/2019A
1/2/2019A
1/3/2019A
1/1/2019B
1/2/2019B
......

 

Thank you for your help

Labels (1)
  • Loop

1 Solution

Accepted Solutions
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

load the first table, than Join the other table

View solution in original post

1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

 

load the first table, than Join the other table