# Iterate over dimension to export files

**URL:** <https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407>\
**Category:** General Q&A\
**Created:** [June 27, 2024, 8:57pm UTC](https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407 "2024-06-27T20:57:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mccanalytics](https://community.easymorph.com/letter_avatar_proxy/v4/letter/m/b3f665/32.png) [@mccanalytics](https://community.easymorph.com/u/mccanalytics)\
**Post date:** [June 27, 2024, 8:57pm UTC](https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407/1 "2024-06-27T20:57:09Z")

</div>

I am looking to iterate over a dimension and create excel exports with filenames based on the dimension value. I have the dimension I want to use isolated in a table and I want to try to create a parameter off the values. After I create the parameter, then I want to finish my transformations and loop over each row of the parameter using it as a filter and also in the file name of the resulting excel file

 ![image](https://community.easymorph.com/uploads/default/original/2X/6/6a39813f5de1cb3b9fb2392e353b576239d17bad.png)

So to summarize, it is open a large QVD, then take distinct values of one column, which could be different through different source files and create a parameter to iterate over and use as a filter and file naming variable.

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [June 27, 2024, 9:25pm UTC](https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407/2 "2024-06-27T21:25:06Z")

</div>

Hi Ken and welcome to the Community!

If I understood the description correctly, you are looking to partition a large QVD file and process each partition individually, saving the result into an Excel file named after the partition.

It can be done with the "Iterate table" action. Еhe project below demonstrates how to use it.

Module "Main"  
[iterate table.morph](https://community.easymorph.com/uploads/short-url/jztXTlKlZsEASiWccB1emUIbnHG.morph) (5.4 KB)

 ![image](https://community.easymorph.com/uploads/default/original/2X/3/338d15e7cc0b2132115df9a81081a56394f761c8.png)

Module "Loop"

 ![image](https://community.easymorph.com/uploads/default/original/2X/0/0783dfab64066bdf8fa679f48214dfb2de3be5da.png)

---

<div class="post-metadata">

**Author:** ![mccanalytics](https://community.easymorph.com/letter_avatar_proxy/v4/letter/m/b3f665/32.png) [@mccanalytics](https://community.easymorph.com/u/mccanalytics)\
**Post date:** [June 28, 2024, 1:32pm UTC](https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407/3 "2024-06-28T13:32:45Z")

</div>

Dmitry, thanks, that worked well. I was able to take it a step further and create unique combinations of two fields and dedup those and feed them to the param in the loop. I appreciate your prompt reply!

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [June 28, 2024, 2:54pm UTC](https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407/4 "2024-06-28T14:54:39Z")

</div>

Thanks for the heads up, Ken. Glad to hear it worked 🙂

---

<div class="post-metadata">

**Author:** ![lunathompson](https://community.easymorph.com/user_avatar/community.easymorph.com/lunathompson/32/6378_2.png) [@lunathompson](https://community.easymorph.com/u/lunathompson)\
**Post date:** [July 3, 2024, 7:29am UTC](https://community.easymorph.com/t/iterate-over-dimension-to-export-files/5407/5 "2024-07-03T07:29:37Z")

</div>

Thanks for the solution, this is very informative.
