-
Re: adding two fields on LOAD
omar bensalem Nov 21, 2017 5:20 PM (in response to Rene Dimarco)Logically,your syntax is good; can u provide a sample excel file of this please; with aybe 10 rows?
-
Re: adding two fields on LOAD
Rene Dimarco Nov 21, 2017 5:25 PM (in response to omar bensalem )Yes, enclosed.
-
CarteraTotal_example.xls 30.5 K
-
-
-
Re: adding two fields on LOAD
Antonio Mancini Nov 21, 2017 5:23 PM (in response to Rene Dimarco)Try
RangeSum(dia30, dia60,dia90,dia120,dia150,diamas) as DeudaTotal
instead
-
-
Re: adding two fields on LOAD
Antonio Mancini Nov 21, 2017 5:37 PM (in response to omar bensalem )Probably some field is null.
-
Re: adding two fields on LOAD
Rene Dimarco Nov 21, 2017 5:37 PM (in response to omar bensalem )May be it has to do with the fact that data is being loaded from Excel? I do not know...
Thanks for your help...
-
Re: adding two fields on LOAD
Rene Dimarco Nov 21, 2017 5:38 PM (in response to omar bensalem )There are some null values on those fields...
-
-
Re: adding two fields on LOAD
Rene Dimarco Nov 21, 2017 5:28 PM (in response to Antonio Mancini)That did the trick!!
Thanks a lot!...
-
-
Re: adding two fields on LOAD
Ramya Sai Nov 21, 2017 5:26 PM (in response to Rene Dimarco)This might work for you.
LOAD
FechaCorte,
lugar as OrigenFactura,
tipo,
rsocial1 as Vendedor,
code as NIT,
rsocial2 as Deudor,
fecha,
factura,
dia30 as deuda30Dias,
dia60 as deuda60Dias,
dia90 as deuda90Dias,
dia120 as deuda120Dias,
dia150 as deuda150Dias,
diamas as deudaMasde150Dias,
sum( dia30 )+ sum(dia60) +sum( dia90) + sum(dia120) + sum(dia150) + sum(diamas) as DeudaTotal
FROM [lib://Soportes Recaudos (vliberal_rdimarco)/CarteraTotal.XLS]
(biff, embedded labels, table is [Cartera Total VL+PG$])
Group by OrigenFactura, tipo, Vendedor, NIT, Deudor, fecha, facture;