Forum Discussion
Helper IIhow 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?
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.
2 Replies
Com o Poqer query, não é possível criar realções, apenas criar atabelas.
Por exemplo, para criar as conexões de dados, será necessário colocar a tabelas no mesmo pradrão de dados.Tabela 01: "Data"
Tabela 02: "Data + Hora"
Tabela 03: "Data + Hora + Segundos"
Para realizar a relacionamento será necessário colocar todas no mesmo padrão:Tabela 01: "Data"
Tabela 02: "Data"
Tabela 03: "Data"
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.
