I am using XML as source and destination profiles, based on the source element i have to populate destination value using CRT Table.
I have a CRT Row to check the input is empty, however it is not working.
I'm moving this product/technical question to Community Forums. This forum is for questions/suggestions about the community itself.
I realize this reply is belated, but if you're still having problems can you please share details about your configuration, maybe screen shots, of your source data values and cross reference table configuration? The CRT assumes an exact match...I might try switching the CRT Data Match to "Wildcard" and adding a row with "*" for the blank match. Make sure this is the last row after all the other matches with actual values.
Be it XML and any other format of files, CRT will work as long as you pass the expected input be it null or empty or space. Coming to your scenario, the input element itself not available while sending to CRT. Because XML does not retain the element unless it receives a value or the empty element is sent explicitly.
what I mean is
<element></element> - in your case this element is not passed i guess. You can test this using a msg shape.
I have done a test and it works fine as long the element is available
Filter out the null values of the input XML data using Decision shape prior to CRT lookup.
This is the most convenient way to filter out some records.
Retrieving data ...