Skip to main content

Comparing Local Data when one of them is empty

Comments

2 comments

  • VISUI

    An "if data error" branch will only be processed if your datalayer returns an errorcode.

    You can build similar functionality with a Union element, by conditioning it based on the length of a sequence column used in the parent datalayer.  You can then return a specific value and test for that within your condition.

     

    <LocalData>
      <DataLayer Type="Static">
        <SequenceColumn ID="seqid" />
        <Join IncludeCondition="len(&quot;@Data.seqid~&quot;) == 0" ID="Union" JoinType="Union">
          <DataLayer Type="Static">
            <StaticDataRow OrderID="99999" />
          </DataLayer>
        </Join>
      </DataLayer>
    </LocalData>
    0
  • VISUI

    In the above example, a static datalayer without a static data row will return no data.  The seqid sequence column will not process (because there is no row of data to process it against).  So the len() of the seqid is zero if no data is returned.

    0

Please sign in to leave a comment.