Skip to Content
0
Jun 11, 2009 at 04:53 AM

Data Manager : Export records to excel

57 Views

Hi MDM pals,

Data manager offers an user to select records in a repository and export them to an excel file.Options exist to choose fields and Qualifiers to be exported.Output file will be a single excel file with all records in distinct columns.

Having said that, I am in need of exporting records in main table and qualified lookup tables with respective qualifiers into different excel files. Please advise how to split the same.

Need stated as below :

1) Excel file 1 : Main table (Customer)

2) Excel file 2 : Qualified Table 1 (Sales Data) - Should contain Sales records(non qualifiers and qualifiers) for each customer.

3) Excel file 3 : Qualified Table 1 (Pricing Data) - Should contain Price records(non qualifiers and Qualifiers) for each customer.

Regards,

Vinay M.S