Skip to main content
Solved

Automating Data Export to generate a file per value in value in control table

  • May 3, 2021
  • 1 reply
  • 53 views

Essentially, I am currently creating csv files from extracts of many TimeXtender tables.  Let suppose the data in a table is a column which identifies each row by country and the table contains many rows for each country, then I would need to create a file for each ISO country that existed in the table. 

I know how to do this by hand, but am wondering if there is a clever way of automating this in TX without having to build an SSIS package?

Thank,

Greg

Best answer by jens.mikkelsen

Hi Greg.

If you make the ISO Country a part of (a field on) your table, you could create a data export for each ISO code, and handle the selection by adding a selection rule to each export.

You will need to create an export for each ISO Code.

Regards Jens Jørn

View original
Did this topic help you find an answer to your question?

1 reply

Hi Greg.

If you make the ISO Country a part of (a field on) your table, you could create a data export for each ISO code, and handle the selection by adding a selection rule to each export.

You will need to create an export for each ISO Code.

Regards Jens Jørn


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings