topic Re: working with excel output file in App Development

working with excel output file

everest226 — Wed, 10 Jan 2018 17:05:01 GMT

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‌

Re: working with excel output file

OmarBenSalem — Wed, 10 Jan 2018 18:06:42 GMT

I did not fully understood ur question; sorry !

Can you be elaborate that more?

Re: working with excel output file

everest226 — Wed, 10 Jan 2018 18:10:00 GMT

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

sunny_talwar — Wed, 10 Jan 2018 18:21:08 GMT

May be

Where RowNo() > 1;

Where FieldName <> 'Formatted Date';

Re: working with excel output file

OmarBenSalem — Wed, 10 Jan 2018 18:30:22 GMT

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

RawTable:

Load * Inline [

];

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:

Re: working with excel output file

AlipNath — Wed, 10 Jan 2018 18:49:43 GMT

guess you meant

Where FieldName <> 'Formatted Date';

working with excel output file

Re: working with excel output file

sunny_talwar — Wed, 10 Jan 2018 18:50:51 GMT

Yes sir

Re: working with excel output file

everest226 — Wed, 10 Jan 2018 18:58:34 GMT

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

sunny_talwar — Wed, 10 Jan 2018 19:12:42 GMT

Where comes after Resident

Re: working with excel output file

OmarBenSalem — Wed, 10 Jan 2018 19:14:42 GMT

everest226 , have u tried this?

Re: working with excel output file

sunny_talwar — Wed, 10 Jan 2018 19:18:03 GMT

Export:

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

Resident ExportNew

Where FieldName <> 'Formatted Date';

drop Table ExportNew;

Re: working with excel output file

everest226 — Wed, 10 Jan 2018 19:38:21 GMT

Thanks , but the record no 1 still shows up

Re: working with excel output file

everest226 — Wed, 10 Jan 2018 19:39:08 GMT

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;

Re: working with excel output file

OmarBenSalem — Wed, 10 Jan 2018 19:47:24 GMT

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

Re: working with excel output file

everest226 — Wed, 10 Jan 2018 20:47:56 GMT

Thanks Sunny