Is there a way while in Design to know how many XML records are in the file being processed by Watch?
Ideally, we would not need to capture this in a Watch process and then use it in the Design, but that could be done. We do near zero stuff with Metadata so that would be possible with help in setting it up, but again it would add a Metadata step to the Workflow which is not ideal.
Our XML structure looks similar to this:
<TABLE>
<INVOICE>
<PP_DIR_OUTPUT>\\PPWATCH1\P\STMT\DAILYNOTICES\0908</PP_DIR_OUTPUT>
<PP_DOCUMENT>DAILYNOTICES</PP_DOCUMENT>
<PP_BRANCH>MICR</PP_BRANCH>
<PP_NUP>1</PP_NUP>
<O_TYPE>C</O_TYPE>
<O_PATH>p:\\stmt\dailynotices\0908\</O_PATH>
<O_PDF>CHECKS_090820.PDF</O_PDF>
<O_TOTPDFS>46</O_TOTPDFS>
<O_PDF_PGNO>6</O_PDF_PGNO>
<ACCTNO>00006778</ACCTNO>
<CHECKNO>000</CHECKNO>
<NEWPDFNAME>DN-Chk_01082B5MNN8GSD9.pdf</NEWPDFNAME>
<PKGBM></PKGBM>
<CTNBM></CTNBM>
<IMBTRACK>85793208</IMBTRACK>
</INVOICE>
</TABLE>
I want the count of the <INVOICE> tags.
Thoughts?