concatenate

[raadwiptec]

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

[avinashelite]

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

[tamilarasu]

Hi,

Sample data would be helpful.

[qlikviewwizard]

Use script as show below:

Load

Customer details.xls

concatenate

Load

New customer file

concatenate

Load

marketing team

Hope this will help you.

[raajaswin]

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

[raadwiptec]

Hi avinash,

What does link key do?

[qlikviewwizard]

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.