invalid indentifier

[ankit777]

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?

[Anonymous]

For all fields:

Select * from Tablename;

for one Field:

Select Fieldname from Tablename;

[gautik92]

select * from Table;

select fieldname from Table;

select fieldname1,fieldname2 from Table;

[ankit777]

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

[sasikanth]

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

[gautik92]

can yu post the code that yu r using

[ankit777]

yes the field is present in data base.

[jagan]

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.

[ankit777]

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

AND

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

[Anonymous]

Then Check as suggested by Jagan.

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