Doubt in FCC

[Former Member]

My input file structure is given below.

The structure of the record also given along with the data in the input file.

Can anyone tell me how to do the Sender FCC for this structure.

#student layout

student_name

student_class

student_section

Nithya

5

a

Dhanya

4

b

rajesh

6

c

#teacher layout

teacher_name

teacher_phone

teacher_class

sita

9842373492

5

ramesh

9842373493

8

anita

9842373494

10

#staff

staff_name

staff_dept

staff_salary

arun

library

1232

baskar

manager

232123

Required xml structure should be

<input_DT> 
   <student>
	<row>
		<name>
		<class>
		<section>
	</row>
   </student>
   <teacher>
	<row>
		<name>
		<phone>	
		<class>
	</row>
  </teacher>
  <staff>
	<row>
		<name>
		<dept>
		<salary>
	</row>
  </staff>

[Former Member]

Hi

This is a multi structure FCC you need to use two mappings in order to read it

Check these it will help

Thanks

Gaurav

[Former Member]

Hi Gaurav,

How can i remove the structure and take only data from the input file

ie

#student layout

student_name

student_class

student_section ,

#teacher layout

teacher_name

teacher_phone

teacher_class etc

[Former Member]

HI

<input_DT> 
   <student>
	
		<name>
		<class>
		<section>
   </student>
   <teacher>
		<name>
		<phone>	
		<class>
  </teacher>
  <staff>
		<name>
		<dept>
		<salary>
  </staff>

This above structure you can get using standard FCC

You can define

Recordset Name = Recordset Name

Recordset Structure = student,3,teacher,3,staff,3,*

student.fieldNames = name,class,selection

student.fieldSeperator = ,

student.endSeperator = 'nl'

student.processFieldNames = fromConfiguration

same for teacher and staff.

Try this if your problem can be resolved.

Thanks

Gaurav

[Former Member]

Hi Gaurav,

Still it is reading the structure.ie

#student layout

student_name

student_class

student_section

How can i read from Nithya by skipping the above structure?

[Former Member]

Hi,

specify number of lines to be remove in the source file in"Document Offset".

Like you want to remove first 4 lines then specify 4 in Document Offset.

It will remove the

#student layout

student_name

student_class

student_section lines.

But it will useful for removing the first 4 lines only.you can not remove other lines which you have in another structure. you need to change the input file.

Check the below link..

[http://help.sap.com/saphelp_nw70/helpdata/EN/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm]

Regards,

Prakasu

Edited by: prakasu on Oct 17, 2008 7:43 AM

[VijayKonam]

If you are practising, it is the most uncommon strucuture to come in real time. Practice something better. the FCC can not handle it directly. You need get all the rows in to mapping then filter them using UDFs or java mapping.

VJ

[Former Member]

Hi

Refer the blog i provided

You can remove the fields from the starting of document using Document Offset

Use a Key field to identity the start of a record structure.

Thanks

Gaurav