Qlik Not Recognizing Fields From QVD File in Data Load

[Daniel16]

Hi all,

I only have limited experience with QlikSense scripting so bare with me if this is a simple fix or if I use incorrect terminology.

In my data load editor, I am trying to load in select fields from a QVD file for an app that was already functional. The new QVD file has more columns added to it as the original data source changed, so I would like to add those fields into my table in my load script in the app. 

When I try to add any new fields to the load script, I get an error and I figured out that it is not recognizing any of these new fields (but still recognizes the fields that were originally in the app). The data is hosted on a remote desktop microsoft azure virtual machine server. Not sure if that's important, but might be worth noting. Why would it not recognize the new fields in the QVD file and how do I fix this error?

Below is a portion of my LOAD script and the bolded are the new fields I am trying to add but are not showing up:

Top50VendorContractDetails2011thru2015_Temp:
LOAD
[dollarsobligated],
[baseandexercisedoptionsvalue],
[baseandalloptionsvalue],
[currentcompletiondate],
[ultimatecompletiondate],

subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',3) & ' / ' & if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='10','Q1',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='11','Q1',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='12','Q1',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='01','Q2',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='02','Q2',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='03','Q2',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='04','Q3',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='05','Q3',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='06','Q3',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='07','Q4',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='08','Q4',
if(subfield(Date([ultimatecompletiondate], 'MM/DD/YYYY'),'/',1)='09','Q4',
'Blank')))))))))))) as [UltimateCompletionDate_FY/Q],
[subcontinent_asian_asian_indian_american_owned_business],
[contracting_officers_determination_of_business_size],
[alaskan_native_servicing_institution],
[native_hawaiian_servicing_institution],
[sba_certified_8a_joint_venture],

[usaspending_permalink],

[highly_compensated_officer_1_name],
[highly_compensated_officer_1_amount],
[highly_compensated_officer_2_name],
[highly_compensated_officer_2_amount],
[highly_compensated_officer_3_name],
[highly_compensated_officer_3_amount]

FROM [lib://CategoryManagement (qlikdemovm_qvadmin)/AllContracts.qvd]
// FROM [lib://CategoryManagement (qlikdemovm_qvadmin)/AllContracts.qvd]
(qvd)
;

Top50VendorContractDetails2011thru2015:
Load
if(not [UltimateCompletionDate_FY/Q] like '*Blank*',
if(ultimatecompletiondate>today(),[UltimateCompletionDate_FY/Q])) as ContractEndDate,
*
Resident Top50VendorContractDetails2011thru2015_Temp;

Drop Table Top50VendorContractDetails2011thru2015_Temp;

[marcus_sommer]

I think you tries to load the wrong file - probably hasn't only changed the data within the file else also the filename and/or the folder - which means you might need to create/update the used lib. Just for testing you could replace all specified fields with a * and also adding filename() as FileName to the load and you will see within the data from where you loaded the file and which fields are really there (the might be also have a different spelling).

- Marcus