Skip to main content

New field in active database

Hello everyone, I have been using IDEA for a couple of months and I have a question.How can I add a new field to my active database with information from another database, without creating a new database?
Thanks for the help
Best!
This is my email: jsrolando.xi@gmail.com

Brian Element Wed, 05/23/2018 - 18:54

Hi JsR and welcome to the site.

Well you would have to create an IDEAScript, how come you don't want to use a join or not create a new database.  Also what information are you trying to get from one file to the other?  Do they have a common key.  I am asking as it can be done in IDEAScript but I would consider this more advance scripting in order to do this.

Thanks

Brian

JsR Fri, 05/25/2018 - 16:51

In reply to by Brian Element

Hello, thank you for your quick response.

I work in a governmental entity that regulates banks.

In my previous work I used ACL and applied this function.

I do not want to create a new database every time I make a union, I just want to add information to the same active database without creating a new one every week.

The information I want to attach are weekly records of each of the banks.

The name of the bank is the key.

If it can not be done, there is no problem. But if there is any script it would be perfect.Thanks!Rolando.

Brian Element Sat, 05/26/2018 - 07:19

Hi JsR,

When you add fields from another file you will have to create a new file by using the join function.  IDEA creates new files when you do any of the tasks such as performing joins.

Brian