topic AW:Field Not Found - <,> Error in QlikView

Field Not Found - <,> Error

Wed, 27 Jan 2010 15:17:29 GMT

Hi,

I'm new to QlikView and trying to teach myself from some reports already created by our Sage Consultant. Trying to add another table to a report to link in some extra data. This should be simple, and I've followed the exact template the consultant has used to create this new link, but I get the below error when I try to reload the data, and I've no idea what the error is relating to.

Field not found - <,>
SQL SELECT *
FROM scheme.opheadm

I've now spent about 3 hours trying different things, but it always comes back to this error no matter what I try. Link to the code I'm using is below:

qualify * ;
unqualify "%_*" ; // unqualify all key fields

invdet:
LOAD customer as %_customer_key,
address1 as DelAddress1,
address2 as DelAddress2,
address3 as DelAddress3,
address4 as DelAddress4,
address5 as DelAddress5,
"invoice_no" as %_inv_number,

;
SQL SELECT *
FROM scheme.opheadm;

// unqualify * here, so that any following tabs will manage the qualify settings wholly within that tab.
unqualify *;

Field Not Found - <,> Error

Wed, 27 Jan 2010 15:22:22 GMT

deleted by user

AW:Field Not Found - <,> Error

Wed, 27 Jan 2010 15:26:17 GMT

Hi its the comma after %_inv_number. Delete it and it should work.

Greetings

Alex:)

AW:Field Not Found - <,> Error

Wed, 27 Jan 2010 15:37:48 GMT

Thanks mate, I knew it would be something as simple as that. There's another 40 odd fields below the code that I've commented out below the Inv line, which is why I didn't spot the comma at the end as I just didn't realise that was the last line.

No longer pulling my hair out. Ta. 🙂