Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

everest226
Contributor III

working with excel output file

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

Tags (1)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: working with excel output file

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 .... ,

14 Replies
OmarBenSalem
Esteemed Contributor

Re: working with excel output file

I did not fully understood ur question; sorry !

Can you be elaborate that more?

everest226
Contributor III

Re: working with excel output file

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

Re: working with excel output file

May be

Where RowNo() > 1;

or

Where FieldName <> 'Formatted Date';

OmarBenSalem
Esteemed Contributor

Re: working with excel output file

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:

Capture.PNG

alip_nath
Contributor

Re: working with excel output file

guess you meant

or

Where FieldName <> 'Formatted Date';

Re: working with excel output file

Yes sir

everest226
Contributor III

Re: working with excel output file

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;

Re: working with excel output file

Where comes after Resident

OmarBenSalem
Esteemed Contributor

Re: working with excel output file

everest226 , have u tried this?

Community Browser