topic Re: concatenate in QlikView

concatenate

raadwiptec — Mon, 19 Oct 2015 07:59:44 GMT

Hi All,

I have 3 customer related files..

1. Customer details.xls which contains all the customers details from the beginning.

2. A New customer file which needs to be concatenated with the existing customer details xls

3.A file which we receive from the marketing team with new customer order details and existing customer new order details

how do I see it to it all these 3 files are in sync

Re: concatenate

avinashelite — Mon, 19 Oct 2015 08:07:50 GMT

if you have similar details i.e. column details in all the files and no repetition, you can go ahead with concatenation .

Otherwise create a link key between all the table and you can use the same in front end develop your charts

Re: concatenate

tamilarasu — Mon, 19 Oct 2015 08:09:12 GMT

Hi,

Sample data would be helpful.

Re: concatenate

qlikviewwizard — Mon, 19 Oct 2015 08:14:06 GMT

Use script as show below:

Load

Customer details.xls

concatenate

Load

New customer file

concatenate

Load

marketing team

Hope this will help you.

Re: concatenate

raajaswin — Mon, 19 Oct 2015 08:15:34 GMT

Hi,

You can check the link by putting common names in qlik view. otherwise as Avinashelite said , If same no of columns are there and all have the same property it is concatenable

Re: concatenate

raadwiptec — Mon, 19 Oct 2015 08:17:36 GMT

Hi avinash,

What does link key do?

Re: concatenate

qlikviewwizard — Mon, 19 Oct 2015 09:08:56 GMT

Hi,

Link table is intermediate table which is used to resolve the loop/synthetic keys.

Check the below links:

What is the use of link table?‌

Creacion Link Table

Qlik Tips: Rules for creating a Key/Link Table in QlikView‌

Concatenate vs Link Table

Check the Linked Table example in Data Modelling.pdf file.

Hope this will help you.