topic Help Needed for Joining in QlikView

Help Needed for Joining

Wed, 22 May 2013 15:13:29 GMT

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

Wed, 22 May 2013 19:01:48 GMT

Hi,

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

Rebeca

jjordaan — Wed, 22 May 2013 19:22:17 GMT

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

I hope this helps

rustyfishbones — Wed, 22 May 2013 19:23:34 GMT

Do you have the same Column header in Both files

If so, you can use Concatenate below is an example

Thu, 30 May 2013 13:37:29 GMT

Thanks for the help

Thu, 30 May 2013 13:37:45 GMT

Thanks for all the help