create more recs, than in the source

[#1]

Hi!

Can anyone tell me, if its possible to make a table with more records than a source table had, but during the load, not loading and joining afterwards with another table?

I mean so that one parent record in a source table have few descendant-records in the result table

Thanks in advance

[#2]

can nested loads  be helpfull?

[Colin-Albert]

Can you give an example of what your source data is and the output you expect?

[#4]

Colin, thank you for responce!

I'm trying to create an app, that calculates debts by periods..

I need to see debts of partners, dew to their "age": wich debts are less then month, which 1-3 months, which 3-6 months... (the best- to be able to choose the limits in the app by user....) User want to see it in different lines or colours of bars..

the payment scheme is FIFO: the new cash transfer goes to repay the oldest debt... So there are "steps"... So I see it like a parent record- the clients debt&start_date and few few descendant-records (repyed part_date of payment), if the debt was not repayed immidiately (was prepeyed)

I need to receive smth like marked in yellow in the end

[#5]

Gysbert Wassenaar, I received an email, that said you replied, but cant see your answer here.

You said its possible... Could you tell me, please,how can I do that? What operators/functions to use?

Thank you in advace

[#6]

I really mean a new record, not a new field in existing record