Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BartVA
Contributor III
Contributor III

Preceding load: field not found

Hello,

I'm trying to do a preceding load but I get the error "Field 'LaunchDate' not found".

If I leave the preceding load out (the part between the comments), it works fine. See code below.

tProduct:
// not working:
    LOAD *,
    makedate(year(Launchdate), month(Today()), Day(Today())) as LaunchYearSameDayAsToday;
// end of part that's not working
    LOAD *,
    date(floor(rangemax(FirstSupplDelNoteDate, EntryDate)), 'DD-MM-YYYY') as LaunchDate
Resident tProductTemp;

 What am I doing wrong?

(The "makedate" formula in itself also works, I tested it separately. It's just in the preceding load that it doesn't work.)

 

I did something similar in a test app, and there it works perfectly:

tPeopleTemp:
Load * Inline [
ID, Name, Age, Title
1, Wladimir, 31, Team Lead
2, Paul, 22, Technical Support Engineer
3, Mark, 40, Customer Support Engineer
4, Janne, 27, IT Specialist
];

tPeople:
Load *,
	"10TimesID" * 10 as "100TimesID";
Load *,
	ID * 10 as "10TimesID"
Resident tPeopleTemp;

Drop table tPeopleTemp;

 

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi,

Could you check the spelling of LaunchDate used in preceding load ?

Looks like that's the issue.

View solution in original post

2 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi,

Could you check the spelling of LaunchDate used in preceding load ?

Looks like that's the issue.

BartVA
Contributor III
Contributor III
Author

You're completely right! I didn't capitalize the "D"... Such a stupid mistake...

Thank you very much!