Question Re: XI Mapping- Filter rows based on source field value in Technology Q&A

XI Mapping- Filter rows based on source field value

Former Member — Tue, 05 Jun 2007 01:48:07 GMT

Hi I am trying to insert rows into a database. From all the rows in the source structure i will need to pick rows based on a source field, if the source field value matches a certain value 'WA' then that row needs to be mapped to the access structure of the target.

Re: XI Mapping- Filter rows based on source field value

Former Member — Tue, 05 Jun 2007 02:38:43 GMT

Vinay,

First of all read the file into XI.

Then you map your condition with createif to the root node of the target ie.,

Condition~~>createif~~>target root node.

So if the condition is true then only your target node will be created.

If this doesnot work due to multiple structures then another option I have is to do multiple mappings. So in the first mapping you send the whole row into XI. Then you parse it up and send the good records to the target. Then you in the second mapping you just map to the target.

---Satish

Re: XI Mapping- Filter rows based on source field value

VijayKonam — Tue, 05 Jun 2007 02:45:40 GMT

Thats a good idea given bby Satish. Also, you might want to create UDF if things really seems to be clumsy in graphical tool (Assumption is you know the basic java for writing the UDF).

Re: XI Mapping- Filter rows based on source field value

justin_santhanam — Tue, 05 Jun 2007 02:49:38 GMT

Vinay,

Can you give the sample source payload - structure.

Best regards,

raj.

Re: XI Mapping- Filter rows based on source field value

Former Member — Thu, 07 Jun 2007 00:42:16 GMT

Raj

Attached are the sample payloads i created to simulate my problem.

Source:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:test1 xmlns:ns0="urn:cop-city:test">

<row>

</row>

<row>

</row>

<row>

</row>

<row>

</row>

</ns0:test1>

Result: after using satish's condition... Check if parm1 is equal to 'A' then createif.

But i had to change the context of parm1 to higher level.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:test2 xmlns:ns0="urn:cop-city:test">

<stmt>

</access>

</access>

</stmt>

</ns0:test2>

Satish thanks for thesuggestion.