I am mapping an X12 EDI 810 Invoice to a SQL updategram. When a SAC
record with a specific attribute value is present I need to generate
another SQl updategram record so I am using the Table Looping and
Table Extractor Functoids.
I am using the Invoice Items (IT1Loop1) Loop as the 1st input to the
Table Looping Functoid and an Equals functoid to check whether or not
the SAC attribute has the value as the 2nd input. For now I only have
2 other inputs, the Item No, which will become a constant and the Unit
Price.
The IT1Loop1 has X elements where X is the number of invoice line
items. The SAC node where the attribute I am looking for is inside of
another loop inside the IT1Loop1 loop.
I have my Table Looping Grid Setup as follows:
Column1 Column2 Column3
SAC Code ItemNo UnitPrice
And Gated is checked
Table Extractor 1 (ItemNo) input 2 is the number 2 for Column2, but
when I connect a string concat, or any functoid for that matter, to
the output of Table Extractor 1 I get an XSLT compile error that looks
like this:
ScriptNS1:StringConcat(string($var:) , "ABC")' is an invalid XPath
expression.
Why is the Table Extractor not providing a value?
Thanks
Greg
