Dynamic keyFieldValue

[Former Member]

Hi all,

i have a problem with key field value.

I receive a flat file with different unknown numbers as key. I have a order number with different positions. So it it possible that i receive 3 rows with the same order number or 1 or 8 or something.

I need a dynamic entry for record.keyFieldValue ORDER Number.

Is this possible and if yes, how?

Example:

key is char 6 - 15:

10I200020102559000115082005110001

10I200020102562000115082005212001

10I200020102565000115082005110001

10I200020102566000415082005110001

10I200020102566000315082005110001

10I200020102566000215082005110001

10I200020102566000115082005110001

10I200020102567000115082005110001

10I200020102567000215082005110001

10I200020102567000315082005110001

10I200020102567000615082005110001

[Former Member · Accepted solution]

Hi

Go thru this blog

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

Regards

Arpit Seth

[Former Member · Accepted solution]

Hi,

thanks for the reply.

I had found this before. But this works with constants like "Voo", "A11"

Not a dynamic number!

[Former Member · Accepted solution]

Hey Thomas,

Have you got any solution for this problem even i have the same problem

Thanks,

Bhargav