Skip to Content
0

Data Services Designer Merge tables

Aug 21, 2017 at 12:16 PM

58

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 06, 2017 at 10:50 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded