Discussion Board for collaboration on QlikView Scripting.
Hi, i have a simple problem. I will join 4 excel tables.
The first 3 tables are the same in the structure. The fourth table have some more information about the customer
So my question is how can i merge this four tables to one table in Qlikview.
I think it should be solved by concatenate and/or joining anyway however.
Thank you in advance.
Go to Solution.
Is this what you are looking for?
Do something like this
// Will automatically concatenate since the table has the same structure as Table1
left join (Table1)
From [Excel 4];
I have tried this myself, this is not working. The problem is that you have to concatenate the first three tables and then join it with the 4. Table, but i didn't find the workaround.
Just like Vishwarant made it, i've got the same result.
Maybe you want something different?
i will check it on monday. Thanks in advance.
Thank you, i think it works. I will check it again with the whole context.
Hi Felip, thank you again. I will check your help also. May be i make a mistake. I will check it and response you. Regards,