Hi,
I have some problem with flat file schema wizard.
The flat file instance I have as input looks like this:
Indicator ... x\r\n
HEAD ........ x\r\n
ITEM ........ x\r\n
ITEM ........ x\r\n
HEAD ........ x\r\n
ITEM ........ x\r\n
ITEM ........ x\r\n
ITEM ........ x\r\n
...
HEAD ........ x\r\n
ITEM ........ x\r\n
ITEM ........ x\r\n
...
As you can see, both HEAD and ITEM is looping, and need to be repeating records.
If I follow the wizzard I can valdidate it, but the generated xml stops with the second HEAD. So the xml looks like this:
<root>
<indocator>
<indocator_child1>....</indocator_child1>
</indocator>
<HEAD>
<HEAD_Child1>...</HEAD_Child1>
</HEAD>
<item>
<items_child1_child1>....</items_child1_child1>
</item>
<item>
<items_child1_child1>...</items_child1_child1>
</item>
</root>
So as you can see, it will not loop the HEAD record, only the first ITEMS.
Can someone help?
[edit]SHOUTING removed - OriginalGriff[/edit]