cancel
Showing results for 
Search instead for 
Did you mean: 

Fcc in Reciever comm channel

gurudatta
Participant
0 Kudos

Hi,

I am using FCC in receiver communication channel and i do not want to display  some filed names in .CSV file.

Is it possible to do this.

Accepted Solutions (0)

Answers (7)

Answers (7)

gurudatta
Participant
0 Kudos

Hi,

I have given space in the map with default but still same output.

I guess there is some problem with FCC configuration.

I have taken one extra(company code) from ECC and I have mapped it to target field and I am using that field in variable substitution but the requirement is to not to display the company code in output csv file

but to display all other field names  and below each field its respective value from ECC in the csv file.

azharshaikh
Active Contributor
0 Kudos

Hi Guru,

But seems you are able to suppress unwanted fields..only issue with Empty values from source rite?

Can you try 1 more option...

Instead of only mapWithDefault function, pls use it & chk alongthwith If-then to pass empty values of required length from Constant as shown below:

Regards,

Azhar

gurudatta
Participant
0 Kudos

Hi Guys ,

Thanks for the replies.

i have tried to ignore the field by giving fixed-length-0 and ItemInvoice.fixedLengthTooShortHandling-cut

buy this the the field is not displayed in the output .csv file

but when some of the mandatory fields are not(ex:text) sent from ECC the output is getting shifted.

i mean the null values should be displayed in the .csv file under the column (text) but in the output file

the values of other fields are getting shifted under text column.

z_item_text value not coming from ECC and should be displayed empty but z_ netdue values shifted to z_item_text

azharshaikh
Active Contributor
0 Kudos

Hi Guru,

You can use MapWithDefault Node function in MM for generating a blank value always incase its not being sent from Sender

Regards,

Azhar

gurudatta
Participant
0 Kudos

Hi,

I have already used map-with default function but is it because of fixed field lengths.

if put i send text abcd in that field the output is coming proper but the problem is with null.

siddhardha_dnk
Active Participant
0 Kudos

Hi,

Use "exists" and "ifelse" for your requirement. It will resolve your issue.

Warm Regards,

Siddhardha Datla.

azharshaikh
Active Contributor
0 Kudos

Hi Guru,

Please re-check if in mapping you have used mapWithDefault (and give a space in it)...

It should work.

Regards,

Azhar

naveen_chichili
Active Contributor
0 Kudos

You need to handle it in mapping in receiver channel you can not ignore specific fields.

Regards,

Naveen

Former Member
0 Kudos

Hi Guru,

you have option to ignore the entire header line

RECORD.addHeaderLine  0

Cheers

Hidayat

former_member184681
Active Contributor
0 Kudos

Hi,

It is not possible to ignore fields during File Content Conversion. As already mentioned, the simplest solution for you is to adjust the mapping not to fulfill certain fields. Also pay attention to whether those fields are mandatory or optional.

Regards,

Grzegorz

0 Kudos

Hi Guru,

       IF u dont want some field names in CVS file means.u can need go for java mapping or module configuration other wise with graphical mapping is not possible to ignore the filed names.

Thanks

srikanth 

azharshaikh
Active Contributor
0 Kudos

Hi Guru,

Can you please elaborate the requirement with example...

You can ignore the unwanted fields in Mapping level itself....

Regards,

Azhar