Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a concern while linking the table Kindly help me. Below is the table structure.
Asset Master -> Hostname, Asset Category, Domain, Location
Call Details-> Ticket ID, Open Date, Status, Close Date, Hostname
Monitoring -> Hostname, Metrics, Value, LogDate
LinkTable--> ID, Date
I want to link Asset Master, call details and Monitoring table through Hostname and want to Link OpenDate, LogDate to LinkTab to create the calender.
Kindly suggest how to do that since it is creating syn.Key or circular Link.
Regards,
Grace@
Try like:
[Asset Master]:
Load
Hostname,
[Asset Category],
Domain,
Location
From <>;
[Call Details]:
Load
Hostname,
Hostname as HostLink,
[Ticket ID],
[Open Date],
[Close Date],
Status
From <>;
[Monitoring]:
Load
Hostname as HostLink,
Metrics,
Value,
LogDate as Date
From <>;
[DateTable]:
Load
ID,
Date
From <>;
but i have to link the [Open Date] and [Close Date] also for Date for Calender purpose..
For that you could take any(that fits your need) out of couple of approaches, like:
- create mutiple calendars for each date type
- create a link table for dates, see details here: Canonical Date
- create multiple date fields in one calendar table itself. May be like:
Load
Date,
Date as [Open Date],
Date as [Close Date]
...;