Hi Folks,
i want to make a short transformation of my table data.

first of all ive got a table file containing the following coloumns:

TABLE FILE TESTTABLE
....

Name | Value1 | Value2 | StartDate | EndDate | DurationMonth
------------------------------------------------------------------------------------------------------------
1 | x |y |03/2013 |05/1013 | 3

For each Month in DurationMonth, i will make a new Row, so that a new table look like this:

Name | Value1 | Value2 | DurationDate
-----------------------------------------------------------------------------------------
1 | x |y |03/2013
1 | x |y |04/2013
1 | x |y |05/2013

Maybe create a new table file SOURCETABLE to store the data.

Can you plz give me a short example how to make this.

Thanks

This post is very similar to what you are trying to achieve.

http://forums.informationbuild...=187102951#187102951

ive tried the code from darin lee:

-SET &ECHO=ALL;
-SET &BEGDATE='19910601';
-SET &ENDDATE='19910612';
-SET &NUMDAYS=DATEDIF(&BEGDATE,&ENDDATE,'D');
-TYPE &NUMDAYS
-SET &DAY=0;
DEFINE FILE TRAINING
COURSEEND/MDYY=COURSESTART+10;
BEGDATE/YYMD=&BEGDATE;
-REPEAT THISLOOP &NUMDAYS TIMES
DAY&DAY/YYMD=DATEADD('&BEGDATE','D',&DAY);
DAYCNT&DAY/I9=IF DAY&DAY GE COURSESTART AND DAY&DAY LE COURSEEND THEN 1 ELSE 0;
-SET &DAY=&DAY+1;
-THISLOOP
END
TABLE FILE TRAINING
SUM
-SET &DAY=0;
-REPEAT PRINTLOOP &NUMDAYS TIMES
DAYCNT&DAY.EVAL AS 'DAY&DAY'
-SET &DAY=&DAY+1;
-PRINTLOOP
END

works fine, but how can i put this in a graph?

greetings

quote:

but how can i put this in a graph

It would have been helpful if you had mentioned that in your original post.

How about this:

...

TABLE FILE TRAINING
SUM
-SET &DAY=0;
-REPEAT PRINTLOOP &NUMDAYS TIMES
DAYCNT&DAY.EVAL AS 'DAY&DAY'
-SET &DAY=&DAY+1;
-PRINTLOOP

ON TABLE HOLD AS HOLDFORGRAPH
END

GRAPH FILE HOLDFORGRAPH
SUM
...
ON GRAPH SET STYLE
...
END

Sry for that.
Im very new on Webfocus.
Is this graph editable?, because the greatest things were, if i can put some filters in it, so that a dashboard user can set the date range.

I will try it tommorrow, the first tries on building a graph on that today have all been failed, but i have made this directly in info asist.

Hmm i get this error:

SUM
-SET &DAY=0;
-REPEAT PRINTLOOP 11 TIMES
(FOC1851) DUPLICATE DASH REPEAT LABEL

Some Ideas?

You can't define the same label more than once in a procedure. Apparently you did.
That's what the error says, at least.

thnx i will look at this.

at the moment this code produces one value for every day in the computed period.

for testing, i have expand the code to compte more than one value for every day like this:

...
DEFINE FILE TRAINING
COURSEEND/MDYY=COURSESTART+10;
BEGDATE/YYMD=&BEGDATE;
-REPEAT THISLOOP &NUMDAYS TIMES
DAY&DAY/YYMD=DATEADD('&BEGDATE','D',&DAY);
DAYCNT&DAY/I9=IF DAY&DAY GE COURSESTART AND DAY&DAY LE COURSEEND THEN 1 ELSE 0;
DAYCNTNEG&DAY/I9=IF DAY&DAY GE COURSESTART AND DAY&DAY LE COURSEEND THEN 0 ELSE 1;
-SET &DAY=&DAY+1;
-THISLOOP
END

TABLE FILE TRAINING
-SET &DAY=0;
SUM
-REPEAT PRINTLOOP &NUMDAYS TIMES
DAYCNT&DAY.EVAL AS 'DAY&DAY'
DAYCNTNEG&DAY.EVAL AS 'DAY&DAY'
-SET &DAY=&DAY+1;
-PRINTLOOP
END

so i will have a additional complement (only for testing, because later i will have 8 values for every day)

so i get a result like this:

DAY0 | DAY0 |.......
1 |40 |.......

in the graph i will put these 2 values for each day shown on DAY0 on the x axis.
But in the moment i am not able to create a graph with a single value.....
thats my 1st problem...

grettings