Primary key (3 column combination)-Qliksense

[Anonymous]

Hi All,

  I need to use 3 columns as primary key to compare the records for incremental load in Qliksense

But when i use exists(column1,column2,colum3) condition.it is not allowing me.So please suggest any other alternative.

In my Database primary key is combination of 3 columns.

[dberkesacn]

concat the fields with and '& ' and try to use that new field.

column1 & '|' & column2 & '|' & column3 as ConcatedFieldKey

Daniel

[Anonymous]

Thanks Daniel,

your suggestion solved my issue.

Regards,

Rajesh.

[Anil_Babu_Samineni · Accepted solution]

I don't prefer to use Composite key rather we can work Autonumber()

POS - Avoid using complex composite keys(when to remove synthetic keys) and instead use the Autonumber() function to generate a sequence which users compact memory

sPlease close this thread by flag helpful and correct answer which resolve for you

HTH

Anil

[dberkesacn]

Hi happy to hear that. please close the question with marking the proper answer helpful and correct.

Thanks,

Daniel

[dberkesacn]

indeed autonumber(column1 & '|' & column2 & '|' & column3) can also be used and could be a better, since QIX can utilize the pure integers more effectively... Thanks Anul Babu Samineni

[Anonymous]

i am new for community..how can i close my post

[dberkesacn]

if you click on the Correct Answer, will close the thread.

[Anil_Babu_Samineni]

I am facing some issues, So that i am sharing my inputs to you all. Glad to hear