Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Highlighted
Partner
Partner

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