merging 2 datasets only imports n-1 columns of data from second set

[mrzpjt]

HI, just tried the merging 2 datasets script,  - have a weird result- 3 columns of data in each set, but only the first 2 from the second set  appear in the merged result. - But  the groups generated automatically say there are 3  columns in each group?  Any idea what I have to change to sort this?

Paddy

[Bjarte Dysvik]

Hi Paddy,

You're right, there is one column missing in the result from the original script. To fix this, change the two for loops:

   keys = keys + [en]
   if rows1.containsKey(en):
      to= rows1.get(en)
      ind = dat1[to]
      
      for i in range(1, len (ind)):
         row = row + [ dat1[to] ]
   else:
      for i in range(1, dat1cols):
         row = row + [ Double.NaN ]

to

   keys = keys + [en]
   if rows1.containsKey(en):
      to= rows1.get(en)
      ind = dat1[to]
      
      for i in range(len (ind)):
         row = row + [ dat1[to] ]
   else:
      for i in range(dat1cols):
         row = row + [ Double.NaN ]

That should do the trick.
I hope you haven't spent too much time on this..

regards,
Bjarte