Referencing Source Data

Situation:

We have a scenario where we want to exclude and entire row of data based on a condition set in the source file? 

Example: If the value in column 1, row 2 is equal to the value in column 1, row 1 we would want to exclude that data.  So in the below example we would want to exclude row 2 because Test1 = Test1.

Test1

Trade1

Test1

Trade1

Test2

Trade2

Test3

Trade3

 

Solution:

Below are the steps to exclude entire row of data based on a condition set:-

1) Take source and target schema.
2) Do one to one mapping.
3) Apply following ForEach on record :" $Input_SchemaName/Root/Record[not(preceding::<<SourceSchema_Column_Name>>=<<SourceSchema_Column_Name>>)] "

screenshot.bmp

Have more questions? Submit a request

0 Comments

Article is closed for comments.