Forum Discussion

RahulKumarBIT's avatar
RahulKumarBIT
Regular Visitor
3 years ago
Solved

Creating a new table using date table and items from other table

Hi I have a date table. I have another table having two columns - ID and category for each id. I want to create a new table which will have 2 columns - Date series from date table and ID. Following ...
  • some_bih's avatar
    some_bih
    3 years ago

    Hi RahulKumarBIT  after you imported your data, new table should be:

    Output Table =
        CROSSJOIN('1st Input - Date Table',
        '2nd Input - ID Table'
    )
    If this helps please kudo.
    If this solves your problem please accept it as a solution.