Linking table having 2 columns in common in qliksense causing circular loop

Aspiring_Developer — Fri, 04 Jun 2021 07:47:17 GMT

Hello everyone,

I have below scenario

TableA:
load
Pid & materialID as 'process index',
Pid as COS_id
From...

===================================
Table B:
load
Tid & Sid as 'PL Index',
Tid & materialID as 'Prcoess Index'
Sid as [Tag_SID],
Sno as [Tag_sno]

From ...

==============================
Table C: // New table to be added in the existing model
load
Tid as cos_id,
Sid as [Tag_SID],
Tstamp
From.....

I want to link the new table (Table C) on cos_id and [Tag_SID] with other tables.
However, it is creating circular loop when i run the data model.

If i don't rename (Sid as [Tag_SID]) in Table C, no circular loop is created and the tables are linked on cos_id field only.

Can any one please help me on how to achieve this ?

Re: Linking table having 2 columns in common in qliksense causing circular loop

Vikash — Sun, 06 Jun 2021 06:21:09 GMT

Hi,

Check the Autonumber() Function. from Help- Autonumber ()