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;
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 .... ,
I did not fully understood ur question; sorry !
Can you be elaborate that more?
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
May be
Where RowNo() > 1;
or
Where FieldName <> 'Formatted Date';
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:
guess you meant
or
Where FieldName <> 'Formatted Date';
Yes sir
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;
Where comes after Resident
everest226 , have u tried this?