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>>)] "
Comments
0 comments
Article is closed for comments.