How to manage KeyFiledValue for great number of value in FCC

[Former Member]

Hello everyone,

I'm facing a logic problem with FCC and key Value for a file to Idoc.

I have a flat file with this strcuture

CCCYYYYMMDDYYYYMMDD999999999999

...

CCCYYYYMMDDYYYYMMDD999999999999

CCC

The last record has always 'OK' as value.

I have create Key on the CCC field.

But my problem, is that CCC has 999 possibility of value.

And I have to interpret the last record (with value OK) before Idoc Mapping

Thanks a lot for your help

JC

[former_member184681 · Accepted solution]

Hi JC,

How about the solution in your previous thread: ? It looks like your problem is exactly the same here, why don't you use the same solution?

Greg

[Former Member · Accepted solution]

Hello Greg,

The solution for preceding was ok, but here, my problem is with the value of the key.

In one file I have always the same value, but I have many file with different value in the key.

And I don't want to create Communication Channel for each origin file received.

Thanks a lot

JC

[Former Member · Accepted solution]

Hello everyone,

No answer on my previous question ?

Thanks a lot

JC

[sunilchandra007 · Accepted solution]

Key field identification seems difficult in your case. The workaround solution will be to use a custom adaptor module or OS level script followed by FCC. The module/script should add a key field before each record except the last one in the file.

Regards,

Sunil Chandra

[Former Member · Accepted solution]

Thanks Sunil,

I have found a solution with your help.

Regards

JC