Field not found - <=>

[#1]

Hey Everyone ,  i need some help over here i don't know why i am getting this error

[undergrinder]

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.

[ramoncova06]

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)'

[#4]

Hey undergrinder

Left JOIN (INV_SALES_TEMP)

LOAD  /* CUR_CURRENCY AS INV_CURRENCY ,*/

CUR_EXCHANGE AS CUR_EXCHANGE3

Resident CURRENCIES Where CUR_CURRENCY = $(vForeignCurrency);

[arthur_dom]

try:

Left JOIN (INV_SALES_TEMP)

LOAD  /* CUR_CURRENCY AS INV_CURRENCY ,*/

CUR_EXCHANGE AS CUR_EXCHANGE3

Resident CURRENCIES Where CUR_CURRENCY = '$(vForeignCurrency)';

[rwunderlich]

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

[undergrinder]

Hi Jhonatan,

You should put your variable into ' ' characters.

Your solution would work, if your variable's type was number.

Examples:

• Where Amount = $(vFoo);  Valid, if Amount and vFoo is also number
• Where City = '$(vFoo)';      Valid, if City and vFoo is string
• Where City = $(vFoo);       Valid, if let vFoo = 'Column name'; in this case vFoo holds a column name.

G.

[#8]

Hey undergrinder,

do i have to set it up before ? or do the mechanism will recognize the

'$(vForeignCurrency)'?

[undergrinder]

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.