Toad World® Forums

Input array is longer than the number of columns in this table.

Using your current parsing settings, not all rows have the same number of columns.
Input array is longer than the number of columns in this table.

i am getting this error when trying to import an xml file.
what I can do to resolve this error?
the said xml file is ~500meg in size.
i have serarched the forums and i found a bit of information on it, but nuthing on how to fix it.

Hi,
I’m not sure what kind xml you are trying to import, I can tell you that TDA only handles pure data xml and does not support advanced features such as style, namespace and encoding etc.

A typical xml data file will have DataTable as root node, table name as child node for each row , and column names as grandchildren for each column.

Here’s an example


1NORTHEAST
2SOUTHEAST
3CENTRAL
4WEST
5OTHER

The error message you got is telling you that not all rows has the same number of column.

If the xml file you are using is exported by TDA, please send it to us for investigation.