Re: Data::Table showing error

[kevbot]

I think you recently updated your node with additional information. It is helpful if you clearly annotate any updates. For example, include a header like UPDATE.

When your file has no header row, Data::Table will create default column names in this format,

col1, col2, col3, etc.

The error you are now getting,

Invalid column col9Unknown column col9 at /root/perl5/lib/perl5/Data/T
+able.pm line 1794.
        Data::Table::group('Data::Table=HASH(0x15e84c0)', 'ARRAY(0xff0
+300)') called at test_table.pl line 13

suggests that there are fewer than 9 columns in your input file.

[ravi45722]

But my input file contains nearly 80 columns.

 Tue Oct 13 00:10:00 2015|33594|959796245242|08211019|Tue Oct 13 00:10:00 2015|Tue Oct 13 00:10:00 2015|CMT|Undelivered|none|Submit|0|SMSC_PR_LC_SMSC_InvalidDestAddress|GSM|INVALID|ASCII|92|92|no||no|no||None|No|NO|no|no|0|0|0|0||959790000028||8|0||0|no|no|default_billing|-1|0|no|no|1|1|1|1|0|1|0|0|||||Tue Oct 13 06:10:00 2015|SR|||IV|011809614446716000046|||0|0||0|0||0||||08211019||||||||||||||||||

This is the sample of my input

[kevbot]

See my other reply in Re^3: Data::Table showing error. You are not defining the delimiter properly, and therefore the data is being loaded as one (very wide) column. Once you set your delimiter properly (for pipe-separated values), you should get multiple columns.