Create multiple records from single line

[evgeniystuchalk]

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?

[its_anandrjs]

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

[swuehl · Accepted solution]

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];

[sunny_talwar]

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

];

[its_anandrjs]

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

[evgeniystuchalk]

exactly what I need Thanks