Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
ShirSandoval
Creator
Creator

PROD CARTESIANO

Buenas noches,

Estoy creando uniones entre algunas tablas para poder tener los datos de varias tablas en una sola. Necesito saber la fecha de pago realizado de cada cuota, pero me genera la cuota con la fecha de pago y duplica la cuota Install con null.

Gracias de antemano.

ShirSandoval_0-1637899052590.png

ShirSandoval_1-1637899225592.png

TMP_Loan:
Load
internalId as internal,
[Loan-SerNr] as N_CONTRATO
Resident Loan;

Outer Join( TMP_Loan)

TMP_LoanInstallRow:
Load
internalId as internal,
num (InstallNr) AS Cuota_Install

Resident LoanInstallRow;


NoConcatenate
Pagos_All:
LOAD
*,
internal as internalId

Resident TMP_Loan;
Drop Table TMP_Loan;

Left Join

LOAD
Num(Prestamo) as N_CONTRATO,
Dominio,
"Nombre y Apellido",
"Fecha Pago" as Fecha_Pago_Realizado,
"N° de Cuota" As Cuota_Paga
FROM [lib://Seguros (qlik_ssandoval)/Pago_Seguros.xlsx]
(ooxml, embedded labels, table is Pago);

Labels (2)
1 Reply
Marcoimp
Partner - Creator III
Partner - Creator III

Sorry Shir,
I'm a little confused... 
Can you explain better what you need?

M.Imperiale