Trouble associating date table

[williamyuen96]

I am having trouble in connecting this two table together. It is very clearly suppose to be in relationship but QlikSense could not detect it somehow and when I forced the relationship the icon turns into red color. Should I be worried about this ? 

[Antoine]

Hello,

I don't really know the meaning of the colors in that visualization ... Could you send us the loading script instead so we can have a better look?

(here in French, but the icons are the same)

Regards,

Antoine

[williamyuen96]

Hi there, i did not use "load editor" to load my data files. Rather, I use data manager

[Antoine]

Fair enough, will let someone with the knowledge on the "Data Manager" reply then.

Have a good day!

[mostwanted123]

Hi,

The error is due to the date column name in both the tables are different.

[williamyuen96]

Correct me if I'm wrong but I thought that it is not possible to have 2 column with the same name even though it is from different table ?

[Antoine]

It is possible to have 2 columns with the name (even more than 2). The columns that shares the same name will be linked (meaning that if you share a column "Date" in two tables A and B, selecting a date in table A, will impact table B).

It's exactly what we're wanting to do in BI, and in data base in general (the shared columns are the "keys" to connect your different tables, and you need them to share the same name, otherwise the software wouldn't recognize them as keys...) 

Here's a small exemple: 

Customer	Customer Name
A	Robert
B	Pablo
C	Jean

Customer	Visit Date
A	03/06/2019
A	02/06/2019
B	05/06/2019
B	03/06/2019

In here, by sharing the "Customer" column between your 2 tables, they are linked automaticly.

Also, I've seen that your "Date" table, is having only one column, so I'm not sure that you really need it... 

Regards,

Antoine