XDO_SKIPROW Usage
Hi All,
I am trying to write a data constraint in an BI Excel template, where I want to SKIP all Blank rows. I did below coding using XDO_SKIPROW function. But some how it is not skipping the blank rows.
Can any one of you based on your experience share where I am going wrong? Attached the Excel template and XML source file.
XDO_SKIPROW_?Bill_Code_Frequency_ID20? | <xsl:if test="string-length(./Bill_Code_Frequency_ID20) != 0"> <xsl:value-of select="./Bill_Code_Frequency_ID20"/> </xsl:if> |
Some how it is not recognising this, my understanding from baove is when string length is not equal to zero, then place the value in cell otherwise it should skip.