Skip to Content
0

How to return the Table name in BODS?

Sep 06, 2017 at 10:56 AM

52

avatar image
Former Member

Hi, I know that flat file can return the file name by enabling the INCLUDE FILE NAME(DI_FILENAME). would this be also possible in tables? I would like to merge tables but I also want to return their TABLE_NAME as well without hardcoding them and using many Variables per table.

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

1 Answer

Best Answer
Ravi kiran Pagidi Sep 07, 2017 at 10:40 AM
0

Hi Charity Cajigas,

You have to hard code it, there is no function to return table_name in bods. Also imgaine if you have multiple source tables in dataflow (joins)

and it will be very difficult to find the tables names using a function in BODS.

Share
10 |10000 characters needed characters left characters exceeded