Skip to Content
avatar image
Former Member

Data Services Designer Merge tables

Hi,

I would like to merge a number of source tables to one table. All tables are identical in structure. The tables are in the same database. The tables are monthly snapshots. I would like to merge all tables based on part of the table name. For example a table name is "Copy201708Patient". Is it possible to set up a workflow that find all tables with name LIKE '%Patient' and merge these tables into one?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 01, 2017 at 07:25 PM
    -1

    As per my experience with these dynamic range of files better build a simple stored proc/View in SQL itself.

    If your source is SQL Server or Oracle you can get the all the tables list where name like '%Patient'

    once you got the list you can loop through with a simple cursor to build the select query and load it into your required target.

    If you want to do in SAP BODS only then,

    Get the count and list of object/Tables list and loop through .

    Regards,

    Sreenivas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2017 at 10:50 AM

    Hi same question here, if flat file has INCLUDE FILE NAME (DI_FILENAME) do tables have that also? So from a single target table I will know to which table the records come from? I mean is this possible?

    Add comment
    10|10000 characters needed characters exceeded