topic Query error in Talend Studio

Query error

Anonymous — Sat, 16 Nov 2024 03:55:30 GMT

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

Re: Query error

TRF — Wed, 04 Dec 2019 18:05:49 GMT

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

Re: Query error

Anonymous — Wed, 04 Dec 2019 18:13:06 GMT

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

Re: Query error

Anonymous — Wed, 04 Dec 2019 19:07:14 GMT

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"

Re: Query error

Anonymous — Wed, 04 Dec 2019 19:09:55 GMT

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

Re: Query error

Anonymous — Wed, 04 Dec 2019 20:04:07 GMT

Re-creating the job solved the problem.