topic How to create a table based on data from an existing table in script in App Development

How to create a table based on data from an existing table in script

Anonymous — Thu, 13 Jul 2017 11:08:27 GMT

Hi,

Is it possible to create the right table based on the existing table on the left in a script ?

My guess is that it can be done with For..Next.

This is what I need:

There is an record in an existing table with ID=A, start Date=June, Units=4 and Value =100.

Based on this I would like to create a new table which has 4 (=Units) lines, each with an amount of Value/Units and a date which starts at the start date and increases with 1 month

Re: How to create a table based on data from an existing table in script

tomasz_tru — Thu, 13 Jul 2017 11:35:06 GMT

Is there an upper limit for the unit field?

Tomasz

Re: How to create a table based on data from an existing table in script

antoniotiman — Thu, 13 Jul 2017 11:42:30 GMT

Hi Eric,

LOAD ID,AddMonths(Date#(StartDate,'1-MMM'),IterNo()-1) as StartDate,
Value/Units as Amount
Inline [
ID,StartDate,Units,Value
A,1-jun,4,100
B,1-feb,2,200
C,1-jul,3,90]
While IterNo() <= Units;

Regards,

Antonio

Re: How to create a table based on data from an existing table in script

Anonymous — Fri, 14 Jul 2017 11:01:54 GMT

Not perse, but I don't expect it to be more than 36 (months)

Re: How to create a table based on data from an existing table in script

Anonymous — Fri, 14 Jul 2017 11:09:40 GMT

Hi Antonio,

Not sure if I understand this fully. You put in the values of the existing table within the Inline statement ( A,1-jun,4,100
B,1-feb,2,200 and C,1-jul,3,90 ).

I need to replace this part of script by a reference to the Existing table as It need to read these lines from the table, right ?

Imagine the existing table name is : OPPS, how should the script look like ?

Re: How to create a table based on data from an existing table in script

antoniotiman — Fri, 14 Jul 2017 11:21:32 GMT

LOAD ID,AddMonths(Date#(StartDate,'1-MMM'),IterNo()-1) as StartDate, Value/Units as Amount

Resident OPPS // if already loaded or From Path\Table.xls or From DB_Table

While IterNo() <= Units;