topic Re: concatenating tables in QlikView https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941790#M324693 <HTML><HEAD></HEAD><BODY><P>You Welcome.</P></BODY></HTML> Mon, 31 Aug 2015 16:46:35 GMT Qrishna 2015-08-31T16:46:35Z concatenating tables https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941787#M324690 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'd like to concatenate two fact tables which have three common fields but most of the fields from the first table are not shared. Is it possible?</P><P></P><P>Fields in table 1:</P><P>Brands</P><P>Advertisers</P><P>Subbrands</P><P><STRONG>Media</STRONG></P><P><STRONG>Month</STRONG></P><P><STRONG>Category</STRONG></P><P>Vehicle</P><P>Cost1</P><P></P><P style="font-size: 13.3333330154419px;">Fields in table 2:</P><P style="font-size: 13.3333330154419px;"><STRONG>Media</STRONG></P><P style="font-size: 13.3333330154419px;"><STRONG>Month</STRONG></P><P style="font-size: 13.3333330154419px;"><STRONG>Category</STRONG></P><P style="font-size: 13.3333330154419px;">Cost2</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I tried:</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Concatenate (table1)</P><P style="font-size: 13.3333330154419px;">load:</P><P style="font-size: 13.3333330154419px;"><STRONG>Media</STRONG></P><P style="font-size: 13.3333330154419px;"><STRONG>Month</STRONG></P><P style="font-size: 13.3333330154419px;"><STRONG>Category</STRONG></P><P style="font-size: 13.3333330154419px;">Cost2</P><P style="font-size: 13.3333330154419px;">resident table2;</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I failed.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Thank you in advance,</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Larisa</P></BODY></HTML> Mon, 31 Aug 2015 16:32:13 GMT https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941787#M324690 Anonymous 2015-08-31T16:32:13Z Re: concatenating tables https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941788#M324691 <HTML><HEAD></HEAD><BODY><P>You have to create a link table else you will lose the granularity.</P><P></P><P>Something like this:<IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97483_1.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 31 Aug 2015 16:33:06 GMT https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941788#M324691 Qrishna 2015-08-31T16:33:06Z Re: concatenating tables https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941789#M324692 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 31 Aug 2015 16:45:37 GMT https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941789#M324692 Anonymous 2015-08-31T16:45:37Z Re: concatenating tables https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941790#M324693 <HTML><HEAD></HEAD><BODY><P>You Welcome.</P></BODY></HTML> Mon, 31 Aug 2015 16:46:35 GMT https://community.qlik.com/t5/QlikView/concatenating-tables/m-p/941790#M324693 Qrishna 2015-08-31T16:46:35Z