Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hello,
Use where clause.
like
Load *
from tableName
where VNOTE = 'OK';
Regards,
Prashant Sangle
Hello,
Use where clause.
like
Load *
from tableName
where VNOTE = 'OK';
Regards,
Prashant Sangle
If(VNOTE = 'OK',VNOTE,NULL()) as VNOTE
Thanks a lot!
Didn't know about "where" func.
It helped!