topic Re: Join 2 field values to create a Primary Key? in QlikView

Join 2 field values to create a Primary Key?

Wed, 25 Nov 2020 16:16:04 GMT

For something like this, I have no unique primary key.

In the script, how would I combine these 3 fields together to create a sort of Primary key?

So it is "123Test1235:45"

Then I would use this key to check against new data to perform an incremental load.

stigchel — Thu, 27 Jul 2017 14:45:51 GMT

You can use &

column1 & '|' & column2 & '|' & column3 as Primary key

But better is:

autonumber(column1 & '|' & column2 & '|' & column3)

Note replace column with your fieldnames

Miguel_Angel_Baeyens — Thu, 27 Jul 2017 14:46:26 GMT

If every row is different, you could use functions like RowNo() or a simple iteration to assign a unique value to each record.

If you need to compare each value, then yes, what you suggest, used in combination with AutoNumber() or similar functions will help.

Anyway, how would you plan to do the incremental load? If all rows are unique, will they ever be replaced?

md_qlikview — Thu, 27 Jul 2017 14:50:59 GMT

Hi,

You may functions like RowNo() or Autonumber(Customer &'_'& Name Time) to unequally identify each record.

md_qlikview — Thu, 27 Jul 2017 14:52:30 GMT

I forgot to concatenate Time on previous reply.

Autonumber(Customer &'_'& Name &'_'& Time)

Thu, 27 Jul 2017 15:20:28 GMT

Thank you!

Thu, 27 Jul 2017 15:20:37 GMT

Thank you!