Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-11-15 11:31 PM

Help in Creating Bridge table

Hi,

I have  two fact tables i want to create an associate  between two fact tables through bridge table.Please help me to create a bridge table for that.

Finally i want connect the bridge table to  bellow link table in model. please find the attachment for sample data.

 

Linktable
Call ID
Medical id
Account ID
Event Id
Message id
segment id

Thanks in advance

Preview file
10 KB
4,500 Views
0 Likes
10 Replies
ElizaF
Creator II
Creator II
‎2016-11-17 02:29 AM

In response to

Use Concatenate(Linktable) function. Also you must to have in the table "LinkTable"  one KEY filed with the FACT1 and FACT2 tables.

From what I noticed the "Medical ID" and "Account ID" fields are found in all of this three tables. So the connection field can be [Medical id]&'#'&[Account ID] AS  KEY.


379 Views
0 Likes