Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help Needed for Joining

Hello,

I am a newbie to this...I hope someone can help.

I am trying to join an Excel file to a DBF to get 1 .qvw file.

Thanks

5 Replies
Not applicable
Author

Hi,

You can read the separate files and then concatenate the script, or use the join.

Rebeca

jjordaan
Partner - Specialist
Partner - Specialist

Hi Alannaalbert,

In QlikView you have few options.

1. QlikView linking tables (based on fieldnames)

2. Concatenate tables

3. Join (Inner, Left, Right)

Depending on the purpose you can choose one of the above examples.

Here are some attachments were you wil find an explanation and also in this blog

http://qlikviewnotes.blogspot.nl/2009/11/understanding-join-and-concatenate.htmlis a good explanation.

I hope this helps

rustyfishbones
Master II
Master II

Do you have the same Column header in Both files

If so, you can use Concatenate below is an example

or check this video https://www.youtube.com/watch?v=bpGsW-Xzvzg

Concat.png

Not applicable
Author

Thanks for the help

Not applicable
Author

Thanks for all the help