Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a script with output excel file . the question is how to remove [Formatted Data] label from first row of excel file
LOAD Category & '|'&Amount & '|'& G1 & '|'& D1& '|'&TT& '|'&TM& '|STSG' as [Formatted Data]
Go to Solution.
What's the script u're using?
LOAD Category & '|'&Amount & '|'& G1 & '|'& D1& '|'&TT& '|'&TM& '|sdfdf' as [FormattedData]
FormattedData as [$(idColumn)]
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
Where RowNo() > 1;
Where FieldName <> 'Formatted Date';
I see, please try to adapt this to ur data:
Load * Inline [
id as [$(idColumn)]
store TableToExport into [lib://Data/testCommunity.csv](txt);
guess you meant
I am having syntax error , did i missed any ,,
drop Table ExportNew;
Where comes after Resident
everest226 , have u tried this?