Discussion Board for collaboration related to QlikView App Development.
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_ENVIRONMENTFROM[$(PathEx)Critical Apps Map.xlsx](ooxml, embedded labels, table is [686 Coll_Server_DB]);
View solution in original post
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.