ContactReview :: View topic - Expression to Insert Value from Destination Table

davidshq · GoldMine Journeyman

Okay, so I didn't understand that GXI was just a table that contained the info. from my source database, and not also the info. from the destination database. I'm trying to update a field, conditionally, with a value but if it doesn't have that value I want to keep the orginal destination database value...how can I do that?
e.g.
If Tx->Phone1 is Empty Get DestinationDb->Phone1.
Dave.

Paul Laufer · GoldBox Guru

During an import, there's TWO temporary DBF files. GXI and TGT. GXI acts as the incoming file and TGT acts as the target database.

GoldBox imports into GXI first, and then updates into TGT after. Those are called the import phase and the update phase. Once TGT is updated, the values are moved up to SQL.

So at the import phase your expressions have access to the source file and the GXI file. At the update phase you have access to the GXI file and the TGT file.

At the top of the map fields screen is a button called "GXI Field Filled" which is probably what you want. It will create an "update expression" that looks something like the following...

IIF(Empty(GXI->Phone1), Tgt->Phone1, GXI->Phone1)

That says in English... if the incoming phone is empty, use the existing phone, else use the incoming phone.

davidshq · GoldMine Journeyman

Thanks Paul. That was very helpful.
Dave.