syntax function" Where" in edit escript?????

[fgolmahi]

Hi Dear Friends

Please help me,I wrote function " Where " in edit script it is ok?

LOAD a,

     b

FROM

[file.xlsx]

(ooxml, embedded labels, table is Sheet1);

Where a=3;

This is error

See attached please

[Anil_Babu_Samineni · Accepted solution]

Remove one semicolon

LOAD a,

     b

FROM

[file.xlsx]

(ooxml, embedded labels, table is Sheet1) Where a=3;

[prma7799]

Remove colon after "(ooxml, embedded labels, table is Sheet1);"

colon means end of the statement

Use colon (;)  after your last code of the script ...

[fgolmahi]

Thanks

[fgolmahi]

Thanks

[prma7799]

Glad to help you....

[fgolmahi]

Hi Dear Friend

Please help me,

How to use Function   " Where " in edit script If Read data from database ( SQL)   ?????

[prma7799]

Like this in Qlikview

LOAD Code as NEW_Code,

     Name as NEW_Name;

SELECT Code,

       Name

FROM [Table Name]

WHERE [Code] LIKE 'PIN' AND [Dimension Value Type] = 0;

And in SQL

SELECT Code,

       Name

FROM [Table Name]

WHERE [Code] LIKE 'PIN' AND [Dimension Value Type] = 0;

[Anil_Babu_Samineni]

You can use either one approach from below

Approach 1

Connection String .....

SQL SELECT a, b

FROM <Table-Name> Where a=3;

Approach 2

Connection String .....

LOAD *  Where a=3;

SQL SELECT a, b

FROM <Table-Name>;

[fgolmahi]

thanks my friend

Approach 2 is correct