cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting a column IN-DB to ID original data source

SOLVED
Highlighted
Brawlstrogg
Meteoroid

Hi folks,

Using the IN-DB function for the first time as it's so much quicker.

 

One thing is, I'm pulling from four databases none of which give me a moniker of where any of the data is from. So what I want to do is add a column to each one that says "DB1" or "DB2" depending on what database I'm getting the data from.

 

I've tried Inserting a column, I've tried the usual way of doing it via the formula however the IN-DB format is way more restrictive so I'm not sure where to go.

 

I figured you guys would have a super easy way of doing this?

 

B.

MSalvage
Fireball

@Brawlstrogg,

 

You should be able to add a formula In-DB after every Connect In-DB that just adds a column that is whatever you want to name the DB.

 

Brawlstrogg Formula Config.PNG

 

Does this not work for you?

 

Best,

MSalvage

 

Brawlstrogg
Meteoroid

It does now... I swear it wouldn't work correctly yesterday. 

 

Thanks buddy.