Skip to main content
Question

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

  • May 3, 2021
  • 1 reply
  • 0 views
G

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

 

    1 reply

    J
    Forum|alt.badge.img

    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

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

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

     
    Cookie settings