On 7 Dec, 13:40, Dan Braun <danbra...@gmail.com> wrote:
> On Dec 7, 1:19 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
>
>
> > On 7 Dec, 12:48, Dan Braun <danbra...@gmail.com> wrote:
>
> > > On Dec 7, 12:04 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> > > > Can you post what the output data you would wish to see is?- Hide quoted text -
>
> > > something like this:
> > > (im assuming that the patchid column can store the unique integer that
> > > is the primary key of the row that should be replaced, so for the
> > > example data:
>
> > > scanario 1 (baseline)
> > > id scenario data patchid
> > > 1 1 100 0
> > > 2 1 100 0
> > > 3 1 100 0
> > > 4 1 100 0
> > > 5 1 100 0
> > > 6 1 100 0
> > > 7 1 100 0
> > > 8 1 100 0
> > > 9 1 100 0
> > > 10 1 100 0
>
> > > scenario 2
> > > id scenario data patchid
> > > 1 1 100 0
> > > 2 1 100 0
> > > 11 2 110 3
> > > 12 2 130 4
> > > 4 1 100 0
> > > 5 1 100 0
> > > 6 1 100 0
> > > 7 1 100 0
> > > 8 1 100 0
> > > 9 1 100 0
> > > 10 1 100 0
>
> > > scenario 3
> > > id scenario data patchid
> > > 1 1 100 0
> > > 2 1 100 0
> > > 3 1 100 0
> > > 4 1 100 0
> > > 5 1 100 0
> > > 6 1 100 0
> > > 13 3 200 7
> > > 8 1 100 0
> > > 9 1 100 0
> > > 10 1 100 0
>
> > > cheers
>
> > > Dan
>
> > Why does Row 4 appear in scenario 2?- Hide quoted text -
>
> > - Show quoted text -
>
> because I cocked up when I pasted in the scenario 2 entries, oops!
> yeah, it would be good if scenario 2 looked like:
>
> scenario 2
> id scenario data patchid
> 1 1 100 0
> 2 1 100 0
> 11 2 110 3
> 12 2 130 4
> 5 1 100 0
> 6 1 100 0
> 7 1 100 0
> 8 1 100 0
> 9 1 100 0
> 10 1 100 0

Are the IDs necessary in the output. I.E. would an output like:

1 1 100 0
2 1 100 0
3 2 110 3
4 2 130 4
5 1 100 0
6 1 100 0
7 1 100 0
8 1 100 0
9 1 100 0
10 1 100 0

also be OK?