Skip to main content

Qlik

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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
3,644 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.


275 Views
0 Likes