Skip to Content
0
Former Member
Feb 20, 2009 at 06:05 AM

Broadcasting queries

29 Views

Hi all,

I have to broadcast a query with following requirements.

Format should be sent as a UTF-8 textfile (i.e. CSV). The delimiter should be a | (pipe) and empty columns should be left empty;

Name of the file sent should be u201Cstand_sapretail_ddmmyyyy.csvu201D. The date should be changing with current date. In example stand_sapretail_24112008.csv;

The header and column names should not be visible;

Example of output report in CSV formate

13333|material|0.01|

As for as I know we can broadcast queries in CSV format but it is not possible to change the separator ( | instead of ;).

Please let me know how this requirement can be achieved using information broadcasting.