How to return the Table name in BODS?

[former_member490928]

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.

[former_member208402 · Accepted solution]

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.