Bring data connection Oracle database table name downstream

Hi all. I have a data connection in which I have SQL code doing a basic select* from a PERSON table in my database. I would like it to dynamically fill in the table name in my formula tool. Currently, I'm entering the table name manually and it's a pain. Any ideas? I'm on 2018.2 if that matters. Thanks!

TABLE NAME.jpg

Workflow

Input

Preparation

Data Investigation

Database Connection

Accepted answers

You could add it to your query, I think this might work:

select *, 'PERSON' as TABLENAME from PERSON

Cheers,

All comments

You could add it to your query, I think this might work:

select *, 'PERSON' as TABLENAME from PERSON

Cheers,

@summarizerWhy don't you add the Table name in your select statement (e.g. Select employee, id, name, 'person' as table)?

Thanks! I am relatively new to SQL. I wasn't even thinking about that! Yep, super easy! Thanks!!!

Yep, thanks John. Feeling a very silly Weds afternoon "duh" moment. Thanks for the advice!!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703