Originally posted by: andrerodriguez

Hello Everybody,

I am pretty new to wtx ,can anyone explain me how to use a restriction list in WTX.
Is restriction list and cross reference the same.
How to use cross reference files.
Is it used to validate type trees???
Plz explain
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Restriction list can be used in couple of ways.
1. In Schema
- While designing the schema you can include the restriction list with in the schema for an item.
- Create a type tree importing the xml schema. Your restriction list will be populated automatically.
2. In Type Tree
For each item to which you need to include restriciton list do the following setting.
- In the extender properties of the item -- change thee restriciton value to "value" -- ignore case to "no" --and restriction rule to "include"
- Double click on the item for which you need to add restriction list and you will be taken to properties of the item which will have two columns Include and Description.
In Include column you can give the restiction list which you want to define.

I recommend Schema approach.

3. Cross referencing and restriciton list both are different concepts. Cross reference you do to lookup for a value, if it is present then pick the corresponding value otherwise leave it. Restriciton list is to validate the incoming value if it is with the list mentioned.
4. Cross reference can be done once you know where your cross reference data is.

Explain the requirement for cross reference, I might help you.

-Thanks and Regards,Rajesekhar Potteti
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: andrerodriguez

Hey Rajasekhar,

Thank you very much for the reply.
For the Cross reference i am looking up model number of an item in a particular product family.

Eg:Product Family A will have items x,y,z(product numbers)
Product Family B will have items i,j,k(product numbers) respectively

so basically check in the input field to see if the product exists(validation basically)

And one more thing these Product family again are country specific.

It goes like this
check the country field---->Then check the product Family(s)of that country---->check the product no.
If i want to build a cross reference table in a database How can i relate this to the tree. Or should i relate this to a map.
Plz help
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

As products are likely to change I wouldn't hardcode them into the input type tree but store them in the database instead (as you suggest).

use the DBLOOKUP function if the number of products is large and the input file is small, if the input file is large and the number of products is small then read the product table as an input card and use the LOOKUP or SEARCHUP functions.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange