Discussion Board for collaboration on QlikView Scripting.
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.
You can read the separate files and then concatenate the script, or use the join.
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
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
Thanks for the help
Thanks for all the help