topic Re: problem in merging the tables in QlikView

problem in merging the tables

anjali0108 — Wed, 07 Oct 2015 07:23:52 GMT

Hi all ,

I have joined two tables A and B ,

and have joined C and D.

Is there any option to concatenate the result of two tables without using any load statement after concatenate .

Thanks in advance.

Regards,

Anjali Ahlawat

Re: problem in merging the tables

pokassov — Wed, 07 Oct 2015 07:28:10 GMT

Hi! No.

Re: problem in merging the tables

kumarkp412 — Wed, 07 Oct 2015 07:30:15 GMT

Hi Anjali,

Can you provide the sample Qvw file.

Re: problem in merging the tables

sujeetsingh — Wed, 07 Oct 2015 07:52:18 GMT

Why load gives some issue? Why avoiding a load then.

Re: problem in merging the tables

Wed, 07 Oct 2015 10:03:01 GMT

HI Anjali,

After joining you get total 2 tables, maintain a keyfield between two tables then at that time you get all total tables information.

As you asked without another load statement this is the process to get all four tables information.

Re: problem in merging the tables

anjali0108 — Thu, 08 Oct 2015 05:54:03 GMT

Actually, I need to merge two tables A and B and have to create a field as 'TSAT_IM' as TCSAT where the Ticket Id is common in both the tables,

Similarly I need To merge two other tables C and D and have to create a field as 'TSAT_SR' as 'TCSAT' where the ticket Id is common in both the fields .

Along with these need to concatenate two more tables E And F .So when I am doing left join on B with A,

I am getting TSAT_IM as a value under TCSAT,

but when I am trying to join D with C,I am not getting 'TSAT_SR'.

Please help if you understood my query .

Thanks in advance.

Re: problem in merging the tables

jonathandienst — Thu, 08 Oct 2015 06:01:57 GMT

>>Please help if you understood my query .

Afraid not. It might help if you posted the script that is not working, preferably in an uploaded qvw sample (sample data files would also help).

Re: problem in merging the tables

Digvijay_Singh — Thu, 08 Oct 2015 06:09:53 GMT

See if this could be one of the possibility - Keep same name of Ticket ID field in all tables and concatenate all tables, if other fields are of more or less same purpose, you may have few different fields in other tables. Then play in front end with different charts, select few dimensions and create expressions sum/count whatever needed to serve the purpose. Qlikview aggregates data in expressions based on selected dimensions in the chart.