|Concatenating logfiles as datasource based on report parameters [message #856031]
||Wed, 25 April 2012 09:54
| Ruben Durk
Registered: April 2012
I have a folder full of log files. Each logfile contains 3 columns:
functionName (String of the function that is called)
data (dateTime of the measurement)
calls (integer of the number of calls in the 5 minute period)
I have 2 servers that each make one logfile a day.
Now what I want to do is to select the appropriate logfiles based on report paramters (e.g. select the data of both servers for the last two days) and merge/join these in one datasource so I can visualize the data.
When joining logfiles from the same server, I just want to keep the 3 columns, but more rows.
When joining logfiles from different servers, I want 4 columns. The 4th column indicates which server produced the data.
Can this be done within Birt? I know of joint data sets, but these produce more columns.
I added 4 example logfiles.
Thanks in advance!
Powered by FUDForum
. Page generated in 0.12571 seconds