BI Publisher (MOSC)

MOSC Banner

XDO_SKIPROW Usage

edited Aug 25, 2023 1:29PM in BI Publisher (MOSC) 15 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center