Query error

[Anonymous]

Hi,

I got "Exception in thread "main" java.lang.Error: Unresolved compilation problems: " when I intend to join a CSV (Sales) with an XLSX (Products)  via a tMap component and to insert the output into tDB_Output Oracle table.

The error comes when I try to map a this expression row3.PRICE *row4.QUANTITY*(1-row4.DISCOUNT) to Sales_Volume target field. I attached a screenshot.

Thanks

[TRF]

Did you try this one?
row3.PRICE * row4.QUANTITY*(new Double(1.0) -row4.DISCOUNT)

[Anonymous]

Have you actually tried this? The expression tester will fail when actual values are not being used. Try running the job.

[Anonymous]

I got when I run the job:
"Error in the component's properties ALE_DATE cannot be resolved or is not a field
COUNTRY_ID cannot be resolved or is not a field
QUANTITY cannot be resolved or is not a field
DISCOUNT cannot be resolved or is not a field
PRICE cannot be resolved or is not a field
QUANTITY cannot be resolved or is not a field
DISCOUNT cannot be resolved or is not a field"

[Anonymous]

I tried this, too. Nope.:-(
Error in the component's properties ALE_DATE cannot be resolved or is not a field
COUNTRY_ID cannot be resolved or is not a field
QUANTITY cannot be resolved or is not a field
DISCOUNT cannot be resolved or is not a field
PRICE cannot be resolved or is not a field
QUANTITY cannot be resolved or is not a field
DISCOUNT cannot be resolved or is not a field

[Anonymous · Accepted solution]

Re-creating the job solved the problem.