I have one table which have dimension CustomerID with duplicates. for each CustomerID there are multiple unique ID. My user don't want to see duplicates in CustomerID when exported to excel. but wants all CustomerID with ID. so, I used Pivot table. In qvw it is showing only once instance of CustomerID with ID, but when exporting to excel it is showing duplicate CustomerID.
How to sort this out. Can anyone help me please.
in your other thread for the same requirement, tresco's response which you marked as the helpful answer, is the way to go about your requirement.
Thanks. I showed the one to the user which I marked as helpful answer. But the user don't want that format. why I marked it as helpful is as others can help from this helpful answer. if any one have this issue and anyone is ok( as it will be different in different organisations) with that format.
Please any other solution.
Store will allow you to define the output fields, and you can create a CSV file for excel to read. Your user can open the file instead of exporting the pivot.
By using Resident, Distinct, Group By etc. you can build a table for excel, and then DROP it when you have finished:
MyfieldB as b
from mytable into xyz.csv (txt);
DROP Table mytable
Alternatively, create a Pivot just for export, with the required columns, and leave it minimised. Instruct the user to right click on that control instead of the displayed version.