Show data in Table with ONLY value after SCRIPT (not in CHART)

[AlexWest]

Hello guys!

I have an Excel table that I'm editing via Scrip.

In that table there are many data and I need to show and work with data that in field VNOTE has a value 'OK'. Excample below.

But, if use "IF" function, I can see my table with 'OK' value, but also I see other data with VNOTE blanc values.

So is it possible to not show at all any data that have no value 'OK' in VNOTE field?

Note: not in chart, I need this solution in script.

Thanks a lot!

[PrashantSangle · Accepted solution]

Hello,

Use where clause.

like 

Load * 

from tableName

where VNOTE = 'OK';

Regards,

Prashant Sangle

[BrunPierre]

If(VNOTE = 'OK',VNOTE,NULL()) as VNOTE

[AlexWest]

Thanks a lot!

Didn't know about "where" func.

It helped!