Forum Discussion

Curious_Curious's avatar
Curious_Curious
Frequent Visitor
3 years ago
Solved

Creating a new column according to reference table

Hello,   I was wondering if someone would be able to help with something I am stuck on. I have the following table (ProductDate) with information in the format below:   Product number Date D...
Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    Hello, here you have two options:

    1. Generate a DIM table (dimension) in which you bring a single value of the products (DISTINC function)
    2. Generate a relationship "many to many" (this is the simplest but remember all relationship 'many to many' or "one to one" are weak and can bring several unwanted results)

    Best regards

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hello, here you have two options:

1. Generate a DIM table (dimension) in which you bring a single value of the products (DISTINC function)
2. Generate a relationship "many to many" (this is the simplest but remember all relationship 'many to many' or "one to one" are weak and can bring several unwanted results)

Best regards