Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
concat the fields with and '& ' and try to use that new field.
column1 & '|' & column2 & '|' & column3 as ConcatedFieldKey
Daniel
Thanks Daniel,
your suggestion solved my issue.
Regards,
Rajesh.
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
Hi happy to hear that. please close the question with marking the proper answer helpful and correct.
Thanks,
Daniel
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
i am new for community..how can i close my post
if you click on the Correct Answer, will close the thread.
I am facing some issues, So that i am sharing my inputs to you all. Glad to hear