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‌

[OmarBenSalem]

I did not fully understood ur question; sorry !

Can you be elaborate that more?

[everest226]

so when i run those script the output file is excel which has [Formatted Data] label in first row shown as in picture. i just want that outfile file without that label in excel

[sunny_talwar]

May be

Where RowNo() > 1;

or

Where FieldName <> 'Formatted Date';

[OmarBenSalem]

I see, please try to adapt this to ur data:

RawTable:

Load * Inline [

  id

  1

  2

  3

];

    let  idColumn=Peek('id',0,'RawTable');

  TableToExport:

Load

  id          as [$(idColumn)]

Resident

  RawTable

Where

  RecNo() > 1;

store TableToExport into [lib://Data/testCommunity.csv](txt);

result:

[Olip]

guess you meant

or

Where FieldName <> 'Formatted Date';

• working with excel output file

[sunny_talwar]

Yes sir

[everest226]

I am having syntax error , did i missed any ,,    

Export:

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

Where FieldName <> 'Formatted Date';

Resident ExportNew;

drop Table ExportNew;

[sunny_talwar]

Where comes after Resident

[OmarBenSalem]

everest226 , have u tried this?