Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to duplicate tables for another tables values

I have a table that does not contain a date column. The value in that column is consisitent for the entire year, but the report is filtered by month. As a result, I cannot visualze values from this table in a monthly report. Therefore, what I am trying to do is the following.

 

I have two tables Saving Target and Dates as follows:

 

 

Suppliers	Target in $	
Heck		255.00
Yummy		650.00
Dual		587.35	


Date
1/4/2021
2/4/2021
3/4/2021
4/4/2021
.
.
.

 

The desired output is as follows:

 

 

Suppliers	Target in $		 Date
Heck		255.00			1/4/2021
Yummy		650.00			1/4/2021
Dual		587.35			1/4/2021
Heck		255.00			2/4/2021
Yummy		560.00			2/4/2021
Dual		587.35			2/4/2021
Heck		255.00			3/4/2021
Yummy		650.00			3/4/2021
Dual		587.35			3/4/2021
.				.				.
.				.				.
.				.				.

 

 

Can anyone help me with this please?

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please try the below for creating a new table.

     

    New Table = CROSSJOIN('Saving Target', Dates)
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    Please try the below for creating a new table.

     

    New Table = CROSSJOIN('Saving Target', Dates)
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM