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.