Re: Multiple datasets in one dataset

From: <roman.morokutti_at_googlemail.com>
Date: Mon, 15 Oct 2007 02:26:04 -0700
Message-ID: <1192440364.149135.233350@q3g2000prf.googlegroups.com>

Hi,

I am sorry about the late response.

Here is the master view. The table indicates a process flow of a piece inside a machine. Each processing stage produces a dataset inside table FOO. There are 6 stages.

Stage 1:
The piece enters the machine.

Stage 2:
Some further processing is made.

Stage 3:
processing ...

Stage 4:
processing ...

Stage 5:
processing ...

Stage 6:
Piece drops out of the machine.

This is the abstractly defined process flow. What exactly gets processed is not defined yet (in other words I don´t know ;-) An example data of this process flow could be:

(just copy the following into a file and call it test.html)

<html><body><table>

	<th>WP</th>
	<th>VALUE_GROUP</th>
	<th>CURR_MS</th>
	<th>VALUE_2</th>
	<th>VALUE_3</th>
	<th>VALUE_4</th>
	<th>VALUE_5</th>
	<th>VALUE_6</th>
	<th>VALUE_7</th>
	<th>VALUE_8</th>
	<th>VALUE_9</th>
	<th>VALUE_10</th>

	<tr>


<td>418</td>

<td>11</td>

<td>27944163</td>

<td>1255</td>

<td>1255</td>

<td>1251</td>

<td>47</td>

<td>46</td>

<td>1242</td>

<td>1290</td>

<td>0</td>
<td>0</td>

	</tr>
	<tr>


<td>418</td>

<td>21</td>

<td>27944163</td>

<td>1255</td>

<td>1255</td>

<td>1251</td>

<td>8</td>

<td>46</td>

<td>1</td>

<td>6432</td>

<td>0</td>
<td>1</td>

	</tr>
	<tr>


<td>418</td>

<td>22</td>

<td>27944163</td>

<td>9987</td>

<td>9987</td>

<td>39</td>

<td>300</td>

<td>350</td>

<td>440</td>

<td>480</td>

<td>500</td>
<td>0</td>

	</tr>
	<tr>


<td>418</td>

<td>23</td>

<td>27944163</td>

<td>1688</td>

<td>429</td>

<td>33</td>

<td>65397</td>

<td>65405</td>

<td>0</td>

<td>0</td>

<td>0</td>
<td>0</td>

	</tr>
	<tr>


<td>418</td>

<td>24</td>

<td>27944163</td>

<td>15</td>

<td>304</td>

<td>355</td>

<td>444</td>

<td>483</td>

<td>538</td>

<td>0</td>

<td>0</td>
<td>0</td>

	</tr>
	<tr>


<td>418</td>

<td>25</td>

<td>27944163</td>

<td>480</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>0</td>

<td>0</td>
<td>0</td>

</tr>
</table></body></html>

So, this would be a process flow where everything went fine. I could make a query where I put all the lines into one. But there are times when a piece crashes inside the machine. Thus I am never sure how many process stages have been passed and how many datasets are written though.

The problem is to define a query where I get all in one line, regardless of how many stages were passed respectively how many lines were written.

Regards
Roman Received on Mon Oct 15 2007 - 04:26:04 CDT