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 ?
