I'm Developing SLAs for one Account, i have a requirement is the combination of ITSM and Telecom. based on these 2 sources i have to showcase data for 1 SLA.
For Telecom i have separate template in that template i will be loading ITSM data by using Ad hoc. here the ITSM data has been loaded but interaction between these two tables not available because there is no matching columns to join in the script. can anyone please help me out how we can join both tables. i tried to join with the company and Account columns but not getting expected result. please find the below columns for reference.
ITSM Columns:
Number, Company sys_created_on, sys_created_on, Type, State, opened_at, closed_at, WaitTime, handling_duration
Technically you can join any field(s) from one table to another table by simply having the same field names.
However your issue is most likely due to the data underneath rather than the fieldnames itself. If those data values dont match completely (case-sensitive), they will not link. You will need to inspect the data before deciding what to link.
here having account column in telecom company in ITSM. but we can give alias name for company for join but this condition also not working. each record getting multiple times that is wrong. so without any matching column is there any possibility to join both tables?
