Reducing loading time

Tue, 09 Mar 2010 03:20:13 GMT

Aftyer spendin a few hours checking in the Forum and the help file, I give up. Can somebody help me with this: I need to load datas from a huge DB. So, in a way to save time in the loading process, and that I don't need all the data's I try to work with the where comand. I try a lot of way to insert this "where" in my script, but no luck in do it work. Here is my script:

SET ThousandSep=',';SET DecimalSep='.';SET MoneyThousandSep=',';SET MoneyDecimalSep='.';SET MoneyFormat='$#,##0.00;-$#,##0.00';SET TimeFormat='hh:mm:ss TT';SET DateFormat='DD/MM/YYYY';SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';SET MonthNames='Ene;Feb;Mar;Abr;May;Jun;Jul;Ago;Sep;Oct;Nov;Dic';SET DayNames='Lun;Mar;Mi�;Jue;Vie;S�b;Dom';ODBC CONNECT TO [Qlik view Capital Humano] (XUserId is XEPCSCRIXCVB, XPassword is KdKOeSRMXDfB);CAPITAL_HUMANO:LOAD Idregistro, Empresa, EmpFicha as Ficha, EmpFechaingreso, EmpFechaBaja, EmpEstadoEmpleado,.... AsgContrato, FechaActualizacion, DAY("FechaActualizacion") AS [DAY], WEEK("FechaActualizacion") AS [WEEK], Day(FechaActualizacion) & '-' & Month(FechaActualizacion) AS FechaDMI, MONTH("FechaActualizacion") AS [MONTH];SQL SELECT *FROM EDW.dbo.Empleados;Store CAPITAL_HUMANO into cAPITAL_HUMANO_2010.qvd;

I would like to select some dates from the field FechaActualizacion (imestampFormat) I'm sure about the syntax of the date I want to select. I try this: SQL SELECT * where [FechaActualizacion] = '07/01/2010 12:00:00 a.m.' and where [FechaActualizacion] = '02/02/2010 12:00:00 a.m.' Can somebody tell me how to do it? I will really apreciate any help in solving this isue. Patrick

Reducing loading time

Tue, 09 Mar 2010 05:58:49 GMT

Hi Dewaegep,

As you say,your syntax is write ,i suggest you to try like

select * from table

where date>=' ' and date <= ' ' ; pls make sure formate of date is supporting your date formate.

regard's

Naren.

Reducing loading time

Tue, 09 Mar 2010 15:12:26 GMT

Naren, thanks, I�m getting close.... but still have a problem: when I wrote this

SQL SELECT *FROM EDW.dbo.Empleados where FechaActualizacion </body>

Reducing loading time

Thu, 11 Mar 2010 17:15:38 GMT

intenta con

SQL SELECT * from ... where [FechaActualizacion] between '07/01/2010' and '02/02/2010'

topic Reducing loading time in QlikView

Reducing loading time

Reducing loading time

Reducing loading time

Reducing loading time