topic Re: Field Not Found Error in App Development

Field Not Found Error

maxwallace — Mon, 16 Jun 2025 15:17:09 GMT

I have a really simple load script where I am trying to load 3 fields from a QVD file that I'm creating and storing in the previous stage of this application. I have checked everything I can think of and can not see why this is happening. I have double checked the variable I'm using for the file path, the file name, the field name in the QVD and everything looks perfect. This all started after I noticed i had a capital letter in the middle of the field name I didn't mean to have so I fixed it. That's when this all started so i changed it back to having the random capital letter and deleted the QVD I had created with the fix so they were all the same with the random capital letter. I have checked every QVD and they're all the same. I am just not sure what to look at next. Its such a simple error and its driving me crazy!

This is the error I am getting.

And this is what the QVD looks like (The string of numbers is the date that it loads. Using the * In the final stage to just pull whatever QVD is there regardless of the date string):

Re: Field Not Found Error

Chanty4u — Mon, 16 Jun 2025 16:29:58 GMT

Delete and Recreate QVD ...( Please take back up before deleting)

And

Check the Path and Filename Wildcard Logic

And

Manually Check the QVD Structure

Re: Field Not Found Error

maxwallace — Mon, 16 Jun 2025 16:34:42 GMT

I have tried deleting, but i create a new one everyday to track our data warehouse loads for QA purposes. I dont want to lose the QVDs we have already created if possible so i can keep the historical data we have already started tracking. Is there a way around it or is this just doing to be the solution?

Re: Field Not Found Error

Adam_Romanowski — Tue, 17 Jun 2025 08:26:48 GMT

Instead of using * wildcard in load clause, you can use for each loop and you will know what files are being loaded, and it's a good practice to use ???????? wildcard if you expect date.

for each vFile in FileList('...????????_STG.qvd')

trace loading file $(vFile);

load ... from [$(vFile)] (qvd);

next vFile