Comments by ips_sun (Top 2 by date)

ips_sun 16-Jul-15 4:18am View

Yup, a document can have more than 2 rows. but it can never be beyond 50. One row in table is one field on the document. two rows means two fields were captured from the document. 50 rows means 50 fields. The report is more of document wise. For each field there are 6 types of values being captured in form of PreValue, PreScore etc. When the 2 fields becomes columns then each row is a document with 2*6 columns. If fields are 10 then when 10 rows becomes columns, the total number of columns will be 10*6 =60 along with Document ID and Class Id.

ips_sun 15-Jul-15 11:10am View

thanks @gregorio89.
There is no logic for Valuechanged. Its just that there should be exactly one record for each document id. If you notice in the result set above in the question the two rows have been reduced to 1 for each document id 123 and 124 respectively. All the rows for each document id should get converted to columns. one document id can have more than 1 fields, each field can have 7 set of values in form of PreValue, PreScore,PostValue, PostScore etc

I hope it helps.