Dataset Load - Logging with Multiple Tables

James T Sidebotham
James T Sidebotham Contributor
in General

Hi,

I have an Excel file(s) that I get sent back to me with data that I need to import into Aperture. The Excel has 2 worksheets in it, and in Aperture the dataset is configured as 2 tables (see screenshot).

I have set up automation to capture when certain datasets are successfully loaded, with the results going to a multi-batch snapshot.

However, only one of the worksheets (REL_CODE in my set-up) gets triggered and the metadata captured (Filename, row count etc.). I would like to capture data about the first worksheet (specifically row count). Am I missing something in my configuration?

Thanks

image.png

Comments

  • James T Sidebotham
    James T Sidebotham Contributor

    Just curious if anyone had taken a look at this and had some input. Thanks

  • James T Sidebotham
    James T Sidebotham Contributor

    Looks like the row count that is provided at the automation is the total number of rows across all sheets (table name). There's no way to break this down by individual tables? Thanks

Categories