Output excel files for each unique field?

Hi Paula,

Yes please see the attached files. This is one way you can approach the challenge;

1. Export Your data as a CSV from the Data Prep Studio
2. Import that CSV into Monarch Classic
3. Create a Summary in Monarch Classic based on the columns you need. I did have to create a 'count' column for this to work.
4. Finally, leverage the ability to export dynamically by a Summary Key in Monarch Classic to create the unique excel file for each country.
5. Run the Export :-)

Here are screenshots of the steps as well;

1. Export Data

2. Import Data as a CSV into Monarch Classic

3. Create a Summary

4. Export by Summary Key:

5. Run the Export :-)

Hi Paula,

Yes please see the attached files. This is one way you can approach the challenge;

1. Export Your data as a CSV from the Data Prep Studio
2. Import that CSV into Monarch Classic
3. Create a Summary in Monarch Classic based on the columns you need. I did have to create a 'count' column for this to work.
4. Finally, leverage the ability to export dynamically by a Summary Key in Monarch Classic to create the unique excel file for each country.
5. Run the Export :-)

Here are screenshots of the steps as well;

1. Export Data

 

2. Import Data as a CSV into Monarch Classic

 

3. Create a Summary

 

 

4. Export by Summary Key:

 

 

5. Run the Export :-)

Thank you so much @Baba Majekodunmi, this was very helpful!

Thank you so much @Baba Majekodunmi, this was very helpful!

You're very welcome @Paula Rodriguez :-).

You should check out the challenges in our Altair Monarch Success Plan.