Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Export:
LOAD Category & '|'&Amount & '|'& G1 & '|'& D1& '|'&TT& '|'&TM& '|STSG' as [Formatted Data]
Resident ExportNew
Where FieldName <> 'Formatted Date';
drop Table ExportNew;
Thanks , but the record no 1 still shows up
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;
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 .... ,
Thanks Sunny