Hello,
Need your help please. I have data table that I whish to filter by using "select where case.
The filtering is by 2 parameters, one is numeric and the other is character.
I don't understand why it's not working when I'm adding the character filter as well.
Your help will be much appreciated.
Another small thing, in this function, to what do I need to change the combo box to get text box with ability to free text instead of choice list?
dt = Open( "\\Vmspfsfslc01\f28_pli\SQL\FE SQL\Data\M0R_tracer.csv" );
Summarize( a = By( :lot ) );
Insert Into( a, "<SELECT traced="" lot="">", 1 );
New Window( "Traced Lot",
<<MODAL> x & :entity == y );
dt << Delete rows;</MODAL></SELECT>
I could be wrong (I don't do scripting, but I am confident someone will soon either confirm or correct me), but I think you need quotation marks around entity = y, i.e. entity = "y" for the nominal variable.
