cancel
Showing results for 
Search instead for 
Did you mean: 

Data filter using receiver determination/Interface determination

Former Member
0 Kudos

Hi Friends,

i have a scenario, which I need to filter the data based on one field that is "Amount field". the source data I am getting as flat file(.txt), The field values is 12 digit(e.g.. 000000000000,009999090000,945884949484).

I wanted to filter the records by Zeros and Nonzero means all the records of [000000000000] into one file and another way.

I used condition editor, it is working fine for string. means if i use 'ABC' in condition (in right appeared) But it is not if I give same way for the above, value 0 or 000000000000.

Thank you

Bala

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

1. See your dataytype, hope you have marked this field as String and not the integer.

2. you can edit the XPATH manually also after putting the value, hope you are entering it as a constant.

regards,

Ravi Siddam

former_member192295
Active Contributor
0 Kudos

Hi,

In Receiver Determination window condition box we can mentioned condition. Take two communication channels for '0's records file and non '0' records file

sourcestructure.field= '000000000000'.............call service1 ('0' records file)

sourcestructure.field# '000000000000'.............call service2 ( non '0' records file)

i think your problem will be sorted out