topic Field not found - <=> in App Development

Field not found - <=>

Wed, 25 Nov 2015 13:55:35 GMT

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

Re: Field not found - <=>

undergrinder — Wed, 25 Nov 2015 16:20:17 GMT

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.

Re: Field not found - <=>

ramoncova06 — Wed, 25 Nov 2015 16:24:51 GMT

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

Re: Field not found - <=>

Wed, 25 Nov 2015 18:00:25 GMT

Hey undergrinder

Left JOIN (INV_SALES_TEMP)

LOAD /* CUR_CURRENCY AS INV_CURRENCY ,*/

CUR_EXCHANGE AS CUR_EXCHANGE3

Resident CURRENCIES Where CUR_CURRENCY = $(vForeignCurrency);

Re: Field not found - <=>

arthur_dom — Wed, 25 Nov 2015 18:32:09 GMT

try:

Left JOIN (INV_SALES_TEMP)

LOAD /* CUR_CURRENCY AS INV_CURRENCY ,*/

CUR_EXCHANGE AS CUR_EXCHANGE3

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

Re: Field not found - <=>

rwunderlich — Wed, 25 Nov 2015 18:49:13 GMT

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

Re: Field not found - <=>

undergrinder — Thu, 26 Nov 2015 08:41:19 GMT

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.

Re: Field not found - <=>

Thu, 26 Nov 2015 09:59:24 GMT

Hey undergrinder,

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

'$(vForeignCurrency)'?

Re: Field not found - <=>

undergrinder — Thu, 26 Nov 2015 11:23:10 GMT

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.