Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I have the following load script to load incident data
LOAD
*,
'1' as Ticket_Count,
[IM Submitter RA] as RA_XREF
FROM [$(Path)IM_Final.qvd](qvd);
But I only want to load incidents from the qvd where the value in the IM_Component_link exists in mapping table that I am loading from Excel. How do I accomplish this?
LOAD COMPUTER_SYSTEM_CI_ID,
[Collection Name],
Subcollections_CI_ID,
Subcollections_NAME,
COMPUTER_SYSTEM_CI_ID1 as IM_Component_link,
COMPUTER_SYSTEM_NAME,
SITE,
ASSET_LIFECYCLE_STATUS,
ENVIRONMENT,
CS_OPERATING_SYSTEM,
INSTANCE_ID,
DB_CI_ID,
DB_NAME,
DB_MODEL,
DB_VERSION_NUMBER,
DB_ENVIRONMENT
FROM
[$(PathEx)Critical Apps Map.xlsx]
(ooxml, embedded labels, table is [686 Coll_Server_DB]);
Thanks Vegar.
I'm getting a "Field 'IM_Component_link' not found" with the Where clause.
Where EXISTS(IM_Component_link, IM_Component_link)
Thanks Vegar. Your solution works perfectly. I had a problem with renamed columns.