Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Everyone , i need some help over here i don't know why i am getting this error
HI Jhonatan,
Could you share the original code snippet?
On the picture I can see an . after LOAD and the where clause is truncated. Hard to say anything based on it.
G.
you are most passing a variable to filter something on the script, try tracing the variable out and see if anything is displayed, another option is to add single quotes to it something like '$(vVariable)'
Hey undergrinder
Left JOIN (INV_SALES_TEMP)
LOAD /* CUR_CURRENCY AS INV_CURRENCY ,*/
CUR_EXCHANGE AS CUR_EXCHANGE3
Resident CURRENCIES Where CUR_CURRENCY = $(vForeignCurrency);
try:
Left JOIN (INV_SALES_TEMP)
LOAD /* CUR_CURRENCY AS INV_CURRENCY ,*/
CUR_EXCHANGE AS CUR_EXCHANGE3
Resident CURRENCIES Where CUR_CURRENCY = '$(vForeignCurrency)';
I agree with Arthur that you need single quotes. But an additional problem is that vForeignCurrency has not value. Where in the script is that variable getting set?
-Rob
Hi Jhonatan,
You should put your variable into ' ' characters.
Your solution would work, if your variable's type was number.
Examples:
G.
Hey undergrinder,
do i have to set it up before ? or do the mechanism will recognize the
'$(vForeignCurrency)'?
Hi Jhonatan,
What do you mean exactly?
If you're thinking about giving value to a variable, I say yes.
SET vForeignCurrency = 'dollar';
and the
...
Resident CURRENCIES Where CUR_CURRENCY = '$(vForeignCurrency)';
should work.
G.