I have created a APD (Analysis Process Designer) in SAP BW. Inside APD I have used Source (Query), Routine and Target (CSV File). Once after executing the APD, I'm getting Header row of the CSV file as both Text and key. I require either Text or either Key but not both.
Could anyone tell me any routine code should be written or any query level changes should be done.
If any routine code is required, Please post the code.
Inside routine no extra code has been written apart from Source and Target fields mapping.