Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jonesbrown
Contributor

What is Concatenation where we use give me an exapmle

Hi All

I am new to Qlikview

What is Concatenation where we use give me an exapmle

plz help.

1 Reply
Rodj
New Contributor III

Re: What is Concatenation where we use give me an exapmle

You can concatenate fields and tables, there's a lot of great information in the help and otherwise online on both of these topics.

If I assume you want to know about concatenation of tables check out the help here: https://help.qlik.com/en-US/sense/September2019/Subsystems/Hub/Content/Sense_Hub/LoadData/step-by-st...

Here's a good tutorial someone clever wrote that includes concatenation and other related data modelling topics: https://hub.packtpub.com/implementing-data-modeling-techniques-in-qlik-sense-tutorial/

Concatenating tables is most often used when you have multiple fact tables that you want to use in your data model. Qlik's unique ability to simply concatenate the tables and reuse your conformed dimensions is a quick and easy way to overcome this data modelling challenge. The alternative is to use a link table. If you google Link Table v's Concatenation you'll find much on this topic.