Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have created a calculated column (ART_FET) in a table (Time_Entry) and am needing to move that column into another table (v_rpt_service). The two columns dont have any similar column titles but they do have a ticket number column that is just named differently in each (SR_Service_RecID and TicketNbr). I am wantting to join the ART_FET column to the v_rpt_service table by referencing the SR_Service_RecID and TicketNbr.
Here is an example of what I am looking for, The column in bold is what I am wanting to move.
Time_Entry Table
SR_Service_RedID | ART_FED | ||||
123456 | 11/5/17 7:30 PM | ||||
123456 | 11/6/17 7:30 PM | ||||
123456 | 11/7/17 7:30 PM | ||||
987654 | 11/8/17 7:30 PM | ||||
987564 | 11/9/17 7:30 PM | ||||
987654 | 11/10/17 7:30 PM | ||||
v_rpt_service Table | |||||
TicketNBR | Entered_By | Time_Start_UTC | Time_End_UTC | First_Time | ART_FED |
123456 | joe | 11/6/17 8:30 PM | 11/6/17 9:30 PM | 11/6/17 8:30 PM | 11/5/17 7:30 PM |
123456 | bob | 11/7/17 10:30 PM | 11/7/17 11:00 PM | 11/6/17 8:30 PM | 11/6/17 7:30 PM |
123456 | tim | 11/8/17 6:30 PM | 11/8/17 7:00 PM | 11/6/17 8:30 PM | 11/7/17 7:30 PM |
987654 | bob | 12/6/17 6:30 PM | 12/6/17 7:00 PM | 12/6/17 6:30 PM | 11/8/17 7:30 PM |
987564 | joe | 12/12/17 9:30 PM | 12/12/17 10:00 PM | 12/6/17 6:30 PM | 11/9/17 7:30 PM |
987654 | tim | 1/11/18 6:30 PM | 1/11/17 7:00 PM | 12/6/17 6:30 PM | 11/10/17 7:30 PM |
Solved! Go to Solution.
Hi Slounsbury
Noticed that you have many to many relationship between these tables. You may need to consider creating bridge table/ relationship table , which is explained in the below URL:
Hope this helps.
Thanks
Raj
Hi Slounsbury
1. In Retaionships Tab, define the relationship between Time_Entry_Table[SR_Service_RedID] = v_rpt_Service_Table[TicketNBR]
2. Now, create a new column using RELATE and use that measure in the v_rpt_Service_Table table.
New_Art_Feed= RELATE ( Time_Entry_Table[ART_FED]).
Hope this helps.
Thanks
Raj
Thank you for your reponse @Anonymous
When I try to build the relationship between these two columns I get an error stating that they must have unique values. Any ideas on what could be cuasing this? I created a new table to get rid of the null values in the Sr_Service_RecID column. The SR_Service_RecID column eventually gest to ticket 284464 but the tickets before that are not needed. Should I delete the tickets that dont have a match in the other column?
Hi Slounsbury
Noticed that you have many to many relationship between these tables. You may need to consider creating bridge table/ relationship table , which is explained in the below URL:
Hope this helps.
Thanks
Raj
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |