Hide data Expression or Script

[bsbernabe]

Hello,

     i have data that i need to hide but i don't know how to do that in expression or script what i want is

like  if(BrancCode= 001') all having BranchCode = 001 should be hide.

Your help would be highly appreciated.

Regards,

Bing

[Anil_Babu_Samineni · Accepted solution]

May be this?

Sample:

Load * from Source;

NoConcatenate

Final:

Load * Resident Sample Where BranchCode <> '001';

Drop Table Sample;

OR

Load * From <Data Sample> Where BranchCode <> '001';

[bsbernabe]

Thank You So Much loveisfail I really appreciate ..

[Anil_Babu_Samineni]

Just to tell you can use Front end like

Sum({<BranchCode -= {'001'}>}Sales)

OR

Only({<BranchCode -= {'001'}>}BranchCode)

[mangalsk]

I guess you don't want that data than to hide ,so as mentioned above you can excluding which loading data using where

Load *

from .... where

not exists(BranchCode ,'001')