Forum Discussion

naifAhmedB's avatar
naifAhmedB
Icon for Helper II rankHelper II
5 years ago
Solved

how to link two data sources in the date table ?

Hi I want to make my date table (calander) daynamic that it brings the date from the data source   I have two data sources daily and hourly , how do i link them togehter in the date table?   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    naifAhmedB 
    Both date columns should have a same name, e.g. "Date" in your case, and set the datatype to date/time. Then you can just use Append Queries feature to combine two tables.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

naifAhmedB 
Both date columns should have a same name, e.g. "Date" in your case, and set the datatype to date/time. Then you can just use Append Queries feature to combine two tables.

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.