Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have table with payments. Like:
I want to generate additional table during load, where for each Deal I have record for each month that included in Pack. Like:
To make this connection:
How I can do it?
Something like
LOAD [Deal ID],
[Price of Pack] / [Month in Pack] AS [Accural Sum],
Date( AddMonths([Purchase Date], iterno()-1) ) AS [Accural Date]
RESIDENT YourTable
WHILE iterno() <= [Month in Pack];
Hi,
You have to use For Loop or Iterno() functions for this on the load script data model.
See some examples on the community on this topics.
Regards,
Anand
Something like
LOAD [Deal ID],
[Price of Pack] / [Month in Pack] AS [Accural Sum],
Date( AddMonths([Purchase Date], iterno()-1) ) AS [Accural Date]
RESIDENT YourTable
WHILE iterno() <= [Month in Pack];
Try this:
Table:
LOAD PricePerMonth,
DealID,
AddMonths(PurchaseDate, IterNo() - 1) as PurchaseDate
While IterNo() <= Month;
LOAD *,
Price/Month as PricePerMonth
Inline [
Price, PurchaseDate, Month, DealID
6000, 18.02.2016, 6, 1
5000, 01.02.2016, 4, 2
];
Hi,
Try this ways
Temp:
LOAD PriceOfPack / MonthinPack as PriceOfPack, AddMonths( PurDate, IterNo()-1) as PurDate ,MonthinPack,DealId,IterNo() as ID
While IterNo() <= MonthinPack;
LOAD PriceOfPack,Date#(PurDate,'DD.MM.YYYY') AS PurDate,MonthinPack,DealId;
LOAD * Inline
[
PriceOfPack,PurDate,MonthinPack,DealId
6000,18.02.2016,6,1
5000,01.02.2016,4,2
];
Regards
Anand
exactly what I need Thanks