on 02-08-2008 3:28 AM
Hi everyone,
Our data type is like this:
Line_Item 1,unbounded
Footer 1,1
In the LINE_ITEM we don't have any key field so we cannot specify key field name in the FCC.
How can we define our FCC for this scenario? Definitely key field option will not work.
Thanks a lot!
Hi all,
The structure of the file is somewhat like this:
LINE_ITEM
DATE
MATERIAL
AMOUNT
PLANT
FOOTER
ID
DATE
TIME
Values in the file would be like this
2007010852345680WN1
2008010953324510WN2
EF20080208120101
Could you tell me how I can define the FCC? Thanks in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mariel,
Going by the pattern of data that you have given, I believe you can use 'DATE' as your key field and proceed.
For eg:
Line_Item...........................0..unbounded
|___ DATE
|___ MATERIAL
|___ AMOUNT
|___ PLANT
Footer............................... 1...1
|__ ID
|__ Date
|__ Time
The content conversion parameters would look like:
Recordset structure: Line_Item,*, Footer, 1
Key Filed Name: DATE
Key field type: Integer
Please let me know, if you need more help.
Regards,
Varun
Mariel,
Since you dont have a key field in content conversion give as Line_Item,9999999999,Footer,1.
Here 9999999999 is the maximum no. of line items you will have. But here you have to make sure that your line items will not exceed this number. If you think it exceeds then increase the 9's accordingly.
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you please provide test file how it looks like.
Strucutre along will not help in giving solutions.
Thnx
Chirag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.