working with excel output file

[everest226]

I have a script with output excel file .  the question is how to remove [Formatted Data] label from first row of excel file

Export:

LOAD Category & '|'&Amount & '|'&  G1 & '|'& D1& '|'&TT& '|'&TM&  '|STSG'  as [Formatted Data]

Resident ExportNew;

omarbensalem‌

stalwar1‌

[sunny_talwar]

Export:

LOAD Category & '|'&Amount & '|'&  G1 & '|'& D1& '|'&TT& '|'&TM&  '|STSG'  as [Formatted Data]

Resident ExportNew

Where FieldName <> 'Formatted Date';

drop Table ExportNew;

[everest226]

Thanks , but the record no 1 still shows up

[everest226]

Stilll show record no 1

Export:

LOAD Category & '|'&Amount & '|'&  G1 & '|'& D1& '|'&TT& '|'&TM&  '|sdfdf'   as  [Formatted Data] 

Resident ExportNew

Where

  RecNo() > 1;

drop Table ExportNew;

[OmarBenSalem · Accepted solution]

What's the script u're using?

try this:

YourTable:

LOAD Category & '|'&Amount & '|'&  G1 & '|'& D1& '|'&TT& '|'&TM&  '|sdfdf'   as  [FormattedData]

from source;

    let  idColumn=Peek('FormattedData',0,'YourTable');

  TableToExport:

Load

FormattedData         as [$(idColumn)]

Resident

  YourTable

Where

  RecNo() > 1;

store TableToExport .... ,

[everest226]

Thanks Sunny