Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I encountered an issue today, that during script loading it appeared the field of "Date" cannot be found. actually it was there as below yellow marked. also it was no problem when i run the same script in earlier days. what could be problems and causes? thanks for the help in advance.
Can you try to load one more time from scratch and see If Prod.Order_Start_Date field is available or not.
check "where" clause? (not visible on your screenshot)
check if you put ";" semicolon after every load or any other statement written previously
You can not refer to the field Date anywhere in the load statement, you have to refer to the Prod.Order start_date. This includes the whole LOAD and WHERE part of the query.