Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Help Needed for Joining

Hi,

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

Rebeca

jjordaan
Valued Contributor

Re: Help Needed for Joining

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
Honored Contributor II

Re: Help Needed for Joining

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

Re: Help Needed for Joining

Thanks for the help

Not applicable

Re: Help Needed for Joining

Thanks for all the help

Community Browser