–SELECT * FROM #table# “table”–
SELECT *,
@umuthcicek welcome to the Knime forum.
These things:
- is X a variable or a value? if value you might have to use single quotes (sql - Error (ORA-00923: FROM keyword not found where expected) - Stack Overflow)
- try to enclose the resulting variable name (Position_From_Country… ) in double quotes
- try so this g else besides the qualifier “table” maybe “t1”
- make sure DB query nodes upstream do not have unwanted comments
You might want to give an example or provide us with a full log file.
2 Likes
Hey @mlauber71 ,
Thanks for your support. What you said helped me fix some of the mistakes, but the main problem was in the *Select *," part.
When I got rid of the max and min expressions in the column names and added all the column names to the query, the code worked fine.
SELECT
WORK_ORDER_CODE ,
WORD900_NAME ,
FROM_ADDRESS_NAME ,
FROM_POSTAL_CODE ,
FROM_CITY_NAME ,
FROM_COUNTRY_CODE ,
TO_ADDRESS_NAME ,
TO_POSTAL_CODE ,
TO_CITY_NAME ,
TO_COUNTRY_CODE ,
EXECUTED_DATE ,
PLANNED_KM ,
EXECUTED_KM ,
TRAILER_PLATE_NR ,
TRIP_TYPE_NAME ,
TRAILER_EMPTY_KM ,
KEY_FIELD_1 ,
KEY_FIELD_2 ,
TRAILER_OWNERSHIP_TYPE ,
TRAILER_TYPE_NAME ,
OPERATION_NAME_ENG ,
STATE_NAME_ENG ,
ACCOUNT_NAME_ENG ,
QUADRO_FROM_CITY_NAME ,
QUADRO_TO_CITY_NAME ,
EMPTY_KM_REASON ,
EMPTY_KM_EXPLANATION ,
TRAILER_EMPTY_EXEC_KM ,
PAY_WEIGHT ,
FIRST_EXECUTED_DATE,
LAST_EXECUTED_DATE,
TOTALKM,
CASE WHEN “EXECUTED_DATE” =“FIRST_EXECUTED_DATE” THEN “FROM_COUNTRY_CODE”
ELSE ‘X’ END AS “Position_From_Country”,
CASE WHEN “EXECUTED_DATE” =“LAST_EXECUTED_DATE” THEN “TO_COUNTRY_CODE”
ELSE ‘X’ END AS “Position_To_Country”
FROM #table# “table”
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.