XI Mapping- Filter rows based on source field value

[Former Member]

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.

[Former Member · Accepted solution]

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