topic Re: Using renamed field name in following script in QlikView

Using renamed field name in following script

Wed, 25 Nov 2020 16:16:04 GMT

Super quick question.

I can't test this now, because the files are in development. Here is my incremental load. Please see the bold.

Can I use Opportunity ID immediately like this? Or do I have to use ID?

NewOpportunity:

Load Product as Opp_Product,

ID as Opportunity_ID

from [new data];

// Add the new data to the old data

Concatenate(NewOpportunity)

LOAD

Product as Opp_Product,

ID as Opportunity_ID

FROM [old data]

where not exists(Opportunity_ID);

Re: Using renamed field name in following script

Miguel_Angel_Baeyens — Thu, 27 Jul 2017 16:02:21 GMT

The first table looks OK, for the second I would change the WHERE to

WHERE NOT EXISTS(Opportunity_ID, ID);

The second ID is the current table [old data] ID.

Re: Using renamed field name in following script

Thu, 27 Jul 2017 16:09:05 GMT

Interesting.

In the examples I saw for incremental load, there was only one parameter for the where not exists. Is this because I renamed my Primary Key?

Re: Using renamed field name in following script

Anonymous — Thu, 27 Jul 2017 16:46:36 GMT

Yes.

If you're 2nd load is from a QVD you'll want to make it where not Exists(ID) so that it stays an optimized load.

And then you can do

RENAME ID to Opportunity_ID

to get the field name what you want.

Re: Using renamed field name in following script

Thu, 27 Jul 2017 18:42:58 GMT

What if I just don't rename then?

I was going to rename since ID is a very general term, but if I dont rename it looks like this

Does this still work?

NewOpportunity:

Load Product as Opp_Product,

from [new data];

// Add the new data to the old data

Concatenate(NewOpportunity)

LOAD

Product as Opp_Product,

ID as Opportunity_ID

FROM [old data]

where not exists(ID);

Re: Using renamed field name in following script

Anonymous — Thu, 27 Jul 2017 18:45:24 GMT

Yes that should work fine.

If you decide you want to though, you can also do this.

NewOpportunity:

Load Product as Opp_Product,

ID,

ID as OpportunityID

from [new data];

// Add the new data to the old data

Concatenate(NewOpportunity)

LOAD

Product as Opp_Product,

ID as Opportunity_ID

FROM [old data]

where not exists(ID);

Drop field ID;

Re: Using renamed field name in following script

Thu, 27 Jul 2017 18:58:18 GMT

Oh that works great, thanks!