Forum Discussion
Why is cardinality Many:Many when a Excel table has a distinct field?
I decided to import a Table ("Workdays") from Excel with the number of work days. It has one row per YEAR_MONTH and the YEAR_MONTH field would be the connection to the BI_Calendar. This should be 1:M...
Anonymous , In table Workdays, is Year_month values are duplicate or null, in that case, you will have many to many
amitchandak
Super User
Super UserAnonymous , In table Workdays, is Year_month values are duplicate or null, in that case, you will have many to many
Blank Cells contained invisible characters. They show up in Excel as blank cells and Excel treated them as blank.