Hi,

I have a master file for an XML file which was created by XML adapter.when I tried to print the data, some columns are missing.

<xml
<header
<col name="VENDOR #">2803069</col
<col name="WEEK">2008-09 WK 1</col
</header
<column_names
<col type="text">VENDOR STYLE</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">SALES UNITS</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">SALES $</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">EOH+OW UNITS</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">EOH+OW $</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">INSTOCK %</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">WOS</col
<col type="numeric" decimals="0" justify="R" powerof="0" dollar_sign=" " percent_sign=" " comma="C" neg_sign="-">AVG SELL PRICE</col
</column_names
<data
<row rownum="1"
<col>SAMPLE</col
<col>2,147,635</col
<col>10,819,832</col
<col>12,193,119</col
<col>69,792,565</col
<col>91.8</col
<col>5.7</col
<col>5.04</col
</row

</data
</xml

Master File SAMPLE_XML:

FILENAME=SAMPLE_XML, SUFFIX=XML     , $
  SEGMENT=XML, SEGTYPE=S0, $
    FIELDNAME=XML, ALIAS=xml, USAGE=A1, ACTUAL=A1,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL), $
    FIELDNAME=HEADER, ALIAS=header, USAGE=A1, ACTUAL=A1,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      REFERENCE=XML, PROPERTY=ELEMENT,  $
    FIELDNAME=COLUMN_NAMES, ALIAS=column_names, USAGE=A1, ACTUAL=A1,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      REFERENCE=XML, PROPERTY=ELEMENT,  $
    FIELDNAME=DATA, ALIAS=data, USAGE=A1, ACTUAL=A1,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      REFERENCE=XML, PROPERTY=ELEMENT,  $
  SEGMENT=COL, SEGTYPE=S0, PARENT=XML, $
    FIELDNAME=COL, ALIAS=col, USAGE=A55, ACTUAL=A55,
      MISSING=ON,
      REFERENCE=HEADER, PROPERTY=ELEMENT,  $
  SEGMENT=COL1, SEGTYPE=S0, PARENT=XML, $
    FIELDNAME=COL, ALIAS=col, USAGE=A55, ACTUAL=A55,
      MISSING=ON,
      REFERENCE=COLUMN_NAMES, PROPERTY=ELEMENT,  $
  SEGMENT=ROW, SEGTYPE=S0, PARENT=XML, $
    FIELDNAME=ROW, ALIAS=row, USAGE=A1, ACTUAL=A1,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      REFERENCE=DATA, PROPERTY=ELEMENT,  $
    FIELDNAME=ROWNUM, ALIAS=rownum, USAGE=A10, ACTUAL=A10,
      MISSING=ON,
      REFERENCE=ROW, PROPERTY=ATTRIBUTE,  $
  SEGMENT=COL2, SEGTYPE=S0, PARENT=ROW, $
    FIELDNAME=COL, ALIAS=col, USAGE=A55, ACTUAL=A55,
      MISSING=ON,
      REFERENCE=ROW, PROPERTY=ELEMENT,  $

When I tried to print the columns, only header data is printing. Is it the problem of master file?

Any help would be greatly appreciated.

Thanks,
WF 7.6.9

This message has been edited. Last edited by: Kerry,

Please put the XML you posted between code tags:

[code]

XML

[/code]

You should also put the master between code tags.

You can edit your original post to do this.

Nope. It is a problem with your xml file. Transform it into something that is more usable and you will be fine.

You have no way to distinguish the data col values, hence they will print as a single column in a report.