To homepage To homepage
Solved

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

  • 3 May 2021
  • 1 reply
  • 37 views
G
Rank

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

icon

Best answer by jens.mikkelsen 4 May 2021, 14:02

View original

1 reply

J
Rank

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 and ConditionsCookie settings