Help Required in Receiver FCC

[Former Member]

Hi All,

my target Xml Structure is like this,

<Message Type>

<Header>

<Name>A</Name>

<EMPID>234</EMPID>

..............

..............

<Grade>B</Grade>

<\Header>

<\Message Type>

I need to write a FCC on the receiver side in such a way that,i dont want some fileds to be present in output text file( eg. Grade should not be present in output txt file). I have created this field in Target structure for some other purpose.

Can anyone please suggest me how to achieve this.

Thanks,

Hemanth.

[former_member206760 · Accepted solution]

Hemanth,

Try what barry has suggested..

else you can also use 2 graphical mappings in 1 interface mapping

1st mapping with source and entire target structure

2nd mapping with input as output of 1st mapping and target as structure without the field that you want

[Former Member]

> I dont want some fileds to be present in output text file( eg. Grade should not be present in output txt file). I have created this field in Target structure for some other purpose.

Can you tell what is the purpose of Grade field, may be we can find some other solution. Because untill and unless you don't remove/disable unwanted fields from your target, you won't be able to get your desired result or use fieldFixedLength with value 0.

Regards,

Sarvesh

[Former Member]

Hi All,

Thanks alot for all of them who gave me suggestions. i have removed that field from the target as it is not mandatory.

Thanks,

Hemanth

[Former Member]

Hi Barry,

Thanks for the response but If i am using fieldseparator in the FCC, then what to do ? because i dont know the exact size of the fields.please help me in this case.

Thanks,

Hemanth.

[Shabarish_Nair]

since you mentioned you dont want some of the fields to be part of the message, the best way is to make sure you dont map it to the target structure. Edit your data type so that those field are not part of your target or instead of editing, you can right click and disable the target fields in your mapping.

[Former Member]

Yes. What Barry has suggest is correct. Use fieldFixedLength and give the value as 0 for those fields which you don't want in your output file.

Regards,

Sarvesh

[Former Member]

You could try using fixedwidth values and assigning 0 for the fields you do not require!