Key Field Value for File Adapter Sender Wildcard

[Former Member]

Hello everybody, is there a way to use a wildcard for the property of NamA.keyFieldValue in the cc for a Fils Sender????, here's an example why, I need to take some Files via PI 7.0 and my key filed can change according to the file an example is that in a file can be HF28 and in another file can be HF29, the only character that is going to be constant is the H, I would really appreciate any suggestions, thanks in advance.

Regards,

Julio Cesar

[Former Member · Accepted solution]

Hi Julio

File sender adapter will read the file using FCC

Key Field Value entry is mandatory if the key field name is set. Otherwise, the entry can be ignored

http://help.sap.com/saphelp_nw70/helpdata/EN/34/393071e9b998438ddb8ce97cd617a1/frameset.htm

Thanks

Gaurav Bhargava

[Former Member]

Thanks to everyone, I requested a little program that inserts the | character so the keys would be as I need them, thanks to everyone.

[Former Member]

Thanks for your answers I've tried your suggestions but it did not worked, I'm going to try to make the thir party coimpany to put the | delimiter after the H and D on every row, and this might work for me I'll let you know if you have any other suggestions would be really appreciated, thanks in advance.

Regards,

Julio Cesar

[Former Member]

HI Julio

Why dont you write a script to modify the file and put key fields. Even using Java proxy you can read such file

Thanks

Gaurav

[Former Member]

Thanks, I'm goign to try both suggestions and I'll let you know soon, thanks for your answers I'll be in touch

[Former Member]

Thanks everyone for your answers, now the problem is that I need to use a KeyValue cause the file contains Header and Detail Data, so I need something to differentiate the Headers an Details, now I can't actually ask a change to the file structure such as including a delimiter so it will be like H|23 cause I don't really have coperation from the 3rd party system, cause there's other applications that also use this files so there would be a lot of changes in different systems and applications, so I need to find a solution that involves only PI, I 'lle keep trying to find an option and I'll let you know, but thanks again for your answers.

Regard's

Julio Cesar

[Former Member]

Hi Julio

As you said now you cant ask for change in file structure and even we cant use * in FCC then read the file as single field itself then use Java mapping or UDF to format it for target.

This can be a work around. Open a SAP note for this

Thanks

Gaurav

[Former Member]

Julio,

if i understood your problem correctly you can do one thing,

i am not sure, but give it a try...

if your file is a fixed length file, just give the length of the key filed as 1, so that it will pick H and then use another field to pick remaining part of the key value.

in mapping just use a string concat to send the complete field to target structure.

[Former Member]

Hi,

Try your FCC without using key field... it should work..

Let us say there are 2 fields in header and 4 fields in detail..

Header.fieldNames = F1,F2

Header.fieldSeparator = ,

Header.endSeparator = 'nl'

Header.additionalLastFields = ignore

Details.fieldNames = F3,F4,F5,F5

Details.fieldSeparator = ,

Details.endSeparator = 'nl'

Details.additionalLastFields = ignore

Regards,

Sarvesh

[Former Member]

Hi Julio,

Recently came across such a scenario. We requested the sender application to produce a delimiter after the first character. Eg. H23 is now H|23 where we have the delimiter as |.

Other option would be to make use of scripts to introduce the delimter.

Once you have the delimiter just give the keyfield value as H.

Regards

Jaishankar

[Former Member]

No, you can not use wildcard for keyFieldValue.

[Former Member]

There is no need to use Key field value at all in sender file content conversion.

Thanx

Aamir