cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion ignore fields

Former Member
0 Kudos

HI ,

I need to ignore some rows in the middle of the data in File content conversion for exaple

H1,Field1,Field2,Field3

A,GB07,MICHEL,1000

H2,Field3,Field4,Field5

B,GB08,andrew,2000

The above is the sample text file from the source , I need to parse in the below

RECORDset1

<Field1>A</Field1>

<Field2>MICHEL</Field2>

<Field3>100</Field4>

RecrodSet2

<Field4>A</Field4>

<Field5>andrew</Field5>

<Field6>200</Field6>

I need to omit or ignore the H1 and H2 rows from the File Content conversion.,

Please guide me how to achive this using File Content conversion

Accepted Solutions (0)

Answers (2)

Answers (2)

iaki_vila
Active Contributor
0 Kudos

Hi Krishna,

You can try with <node>.keyFieldInStructure – ‘ignore’, also you can avoid the tags in the mapping.

Regards.

binod8
Active Participant
0 Kudos

Hi Krishna,

In case if H1 and H2 is your record type or line type then to ignore line for this type... just do not handle "keyFieldValue" in the content conversion for H1 and H2 record type.

Thanks,

Binod