Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a field (id_Personal) with values 08, 06, 03 to pass to qlikview I get 8,006,003.
Use the following syntax:
OLEDB CONNECT TO [Provider = SQLOLEDB.1; Persist Security Info = True; User ID = qlikview; Initial Catalog = Storage, Data Source = melodepo; Use Procedure for Prepare = 1; Auto Translate = True; Packet Size = 4096; Workstation ID = SRVQLIKVIEW; Use Encryption for Data = False; Tag with column collation When possible = False] (XPassword is OKNSdQRMNLaADbEGQRPB);
LOAD "Id_Compania"
"Fecha_Transaccion", "Id_Personal"
EmpCod;
SQL SELECT *
FROM Deposito.dbo. "Historico_Movimiento_Encab"
Where year (Fecha_Transaccion)> = 2013;
how to make passes exactly the same values.
Please help,
Rolando
Maybe you need trim values, so use this
LOAD "Id_Compania"
"Fecha_Transaccion",
num(trim("Id_Personal"),'00') as Id_Personal, // Or 000 if you want 3 digits
EmpCod;
SQL SELECT *
FROM Deposito.dbo. "Historico_Movimiento_Encab"
Where year (Fecha_Transaccion)> = 2013;
After doing tests with the recommendations, I still have the same problem described:
the field in the database is 3 digits, may have id_personal with 2 or 3 digits, for example:
Table Historico_Encab(database) Qlikview Tabla_Personal(database)
Id_Personal: 08 008 08
06 006 06
are not equal: qlikview(Tabla historico_Encab) and tabla_personal:
Helpme please
thank you all for the cooperation