Forum Discussion
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...
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
Hello how are you?, I understand what you want to do, but the easiest way is simply to generate a relationship between these tabalas and you can create the table within the dashboard without problem
Thank you for your response. I was considering this but I am not really sure how to create a proper working relationship between those tables as the product number appears many times in the first two tables.