If the data is already loaded (ie, it has been executed earlier in the script):
NoConcatenate NewTable: Load * Resident [The Original Table With All Your Data] Where Hours > 0; Drop [The Original Table With All Your Data];
You could also put the WHERE clause in your initial load of the data to prevent it being loaded in the first place.
Hope this helps
Thank you for you answer, both of you, but where do I put it?
[Fecha] as "Fecha Registro",
[Proyecto] as ProyectoPlanif,
[Categoria General] as CategoriaGeneralPlanif,
[Mes] as MesPlanif,
[Año] as AñoPlanif,
FROM [lib://audit con/archivos plani/Horas pla.xls]
(biff, embedded labels, header is 1 lines, table is sheet1$) Where Hours > 0;
Just to be sure, remember that I what to exclude "Name" when "Hours" > 0
You wont be able to do this other than from a preloaded file or from a .qvd pre-created file - other than that and much the same as the other post you need to load the data first then select using where statement
LOAD * INLINE [
load * Resident Data Where Hours > 0;
drop table Data;
You may be able to do this without preloading by using an INPUT box in the load script and associating the input as a variable in the WHERE statement - but you still would need the data pre-loaded or existing as a QVD.