Hi Team I am creating data model in my workspace. I have done below steps: 1- Created workspace 2- Connect database Now I am creating data model, but I have one question : My scenario is : I have three table User and Role and Department Role 1 ....N User (i.e. Role has many Users) And Department 1....N User (i.e. Department has many Users) User Table id | Name | department_id | role_id 1 | John | 1 | 2 2 | Kane | 2 | 1 3 | Henry | 1 | 2 Role Table id | Name 1 | Engineer 2 | QA Department Table id | Name 1 | Manufacturing 2 | Quality My Question is : I don't want to add Role and Department table while creating model, Instead of that can we merge Role and Department table with User Table E.g. something like below id | Name | department_id | Department Name | role_id | Role Name 1 | John | 1 | 2 | Manufacturing | QA 2 | Kane | 2 | 1 | Quality | Engineer 3 | Henry | 1 | 2 | Manufacturing | QA can we merge table while creating model?

Hi Gaurav, you currently can not perform data transformation in the data model in GoodData. You can for sure use the merged table for your data model, but first you will need to either create such table physically in your database or create a view there which will join these tables. Then you can use this resulting view/table in your GoodData data model easily.