Join 2 field values to create a Primary Key?

[#1]

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.

Customer	Name	Time
123	Test123	5:45
555	Increment	6:56
555	Test123	4:20

[stigchel · Accepted solution]

You can use &

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

But better is:

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

Note replace column with your fieldnames

autonumber ‒ QlikView

[Miguel_Angel_Baeyens]

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]

Hi,

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

[md_qlikview]

I forgot to concatenate Time on previous reply.

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

[#6]

Thank you!

[#7]

Thank you!