0 Replies Latest reply on Dec 1, 2015 5:14 PM by user10858693

    Export Mapped Files to Excel

    user10858693

      We are considering using Planning for a certain set of data, however before setting up the application we need to do some data clean up.  What I would like to do is develop mappings for data, transform it through FDQM and then rather than load to Planning, export the transformed data to Excel.

       

      As a simple example, say I have two columns of data, one being a description and the other values, and say the descriptions are A & B with values of 1 & 2 respectively.  I would like to map A & B to C.  When I load the file from Excel it is transformed and exported with C as the description and a value of 3.

       

      The issue is that we have 1) a lot of quality issues in the data set and 2) we have limited resources.  If I cannot show proof of concept, then I probably don't get the resources.  My hope was to use FDQM in cleaning up the data and then showing proof of concept.  Once we got the go ahead there, I create a Planning database and simply use the same maps we had been working with to clean the dataset.

       

      Thank you for any suggestions the community may have!