x4j-analytic icon indicating copy to clipboard operation
x4j-analytic copied to clipboard

Published 20 hours ago • verified publisher icon jbaliuka

How to Identify the errors occured in transaform ?

Open shyjuck opened this issue 8 years ago • 6 comments

shyjuck avatar Dec 22 '16 09:12 shyjuck

Hi,

It would be great if you let me know how can I identify the error happens in 'transaform' process. There is no error in console, but the data from Result Set are not loading to Excel.

shyjuck avatar Dec 22 '16 09:12 shyjuck

Probably result set is empty, "transform" should simply throw an exception on error

jbaliuka avatar Dec 22 '16 21:12 jbaliuka

Hi,

The resultset is not empty. Will give an error/warning on mismatch of column names in Query and Pivot Template ?

shyjuck avatar Dec 25 '16 04:12 shyjuck

It will output blank cell becasue we interpred culums as Map keys, try all lower cae or all upper case

jbaliuka avatar Dec 25 '16 20:12 jbaliuka

Is there anything specific we need to care while creating the Pivot Template ?

shyjuck avatar Dec 26 '16 05:12 shyjuck

Pivot is broken with newer Excel versions (since Excel 2012) because newer Excel validates numeric cells and discards placeholders

jbaliuka avatar Dec 27 '16 08:12 jbaliuka