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;
