Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
need your help here 
I have some records like below, every records has a error data and a close date.
table A:
| ID | erro date | close date |
| 1001 | 2015/1/1 | 2015/1/3 |
| 1002 | 2015/2/1 | 2015/2/5 |
I want to generate more records if the close date is bigger than error date. for this sample I wan this below
table B:
| ID | error date | close date |
| 1001 | 2015/1/1 | 2015/1/3 |
| 1001 | 2015/1/2 | 2015/1/3 |
| 1002 | 2015/2/1 | 2015/2/5 |
| 1002 | 2015/2/2 | 2015/2/5 |
| 1002 | 2015/2/3 | 2015/2/5 |
| 1002 | 2015/2/4 | 2015/2/5 |
My question is could I write scripts to generate B through load from table A.
Accepted Solutions
Try this:
Table:
LOAD ID,
[close date],
Date([erro date] + IterNo() - 1) as [erro date]
While ([erro date] + IterNo() - 1) < [close date];
LOAD * Inline [
ID, erro date, close date
1001, 2015/1/1, 2015/1/3
1002, 2015/2/1, 2015/2/5
];
Try this:
Table:
LOAD ID,
[close date],
Date([erro date] + IterNo() - 1) as [erro date]
While ([erro date] + IterNo() - 1) < [close date];
LOAD * Inline [
ID, erro date, close date
1001, 2015/1/1, 2015/1/3
1002, 2015/2/1, 2015/2/5
];
