topic Re: invalid indentifier in QlikView

invalid indentifier

ankit777 — Thu, 05 Nov 2015 06:10:22 GMT

Hi All,

I am trying to load a table using Sql. When I use select *, one particular field is not loaded.

When I use select "fieldname", then I get a Invalid Identifier error.

How can I load that field?

Re: invalid indentifier

Anonymous — Thu, 05 Nov 2015 06:13:06 GMT

For all fields:

Select * from Tablename;

for one Field:

Select Fieldname from Tablename;

Re: invalid indentifier

gautik92 — Thu, 05 Nov 2015 06:51:39 GMT

select * from Table;

select fieldname from Table;

select fieldname1,fieldname2 from Table;

Re: invalid indentifier

ankit777 — Thu, 05 Nov 2015 06:58:38 GMT

I don't think I explained that well.

When I use

select * from Table

- One of the column named x, is not fetched.

However, when I use

select x from Table;

-I get error Invalid Identifier

Re: invalid indentifier

sasikanth — Thu, 05 Nov 2015 07:02:45 GMT

Did you check weather that Field is available in Database or not?

Re: invalid indentifier

gautik92 — Thu, 05 Nov 2015 07:02:46 GMT

can yu post the code that yu r using

Re: invalid indentifier

ankit777 — Thu, 05 Nov 2015 07:06:53 GMT

yes the field is present in data base.

Re: invalid indentifier

jagan — Thu, 05 Nov 2015 07:07:51 GMT

Hi Anikit,

Try like this

Edit Script -> Select -> Select Table -> Select required columns -> Click OK button.

See how Qlikview generates the SQL Query.

Hope this helps you.

Regards,

Jagan.

Re: invalid indentifier

ankit777 — Thu, 05 Nov 2015 07:09:22 GMT

LOAD "FIELDNAME_1";
SQL SELECT "FIELDNAME_1"
FROM "SCHEMA"."TABLE";

AND

SQL SELECT * FROM "SCHEMA"."TABLE";

Re: invalid indentifier

Anonymous — Thu, 05 Nov 2015 07:10:37 GMT

Then Check as suggested by Jagan.

It seems that field required some quotes may be like `FieldName` or 'Fieldname' or "FieldName"