Blank field name not allowed

[everest226]

Getting following error while output excel file 

Blank field name not allowed

TableToExport:

Load

FormattedData         as []

Resident

  Export

Where

  RecNo() > 1

[Peter_Cammaert]

In a load script, you cannot load data into a column/field without a name. There would be no means to retrieve anything from that field either, so what is the use?

[Peter_Cammaert]

Are you using $-sign expansion in your load to assign names to columns/fields? If so, check the content of those variables immediately before performing the load.

[everest226 · Accepted solution]

thanks, there was problem with months field so basically there was no data , after i made that changes same script worked . thanks