problem in merging the tables

[anjali0108]

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

[pokassov]

Hi! No.

[kumarkp412]

Hi Anjali,

Can you provide the sample Qvw file.

[sujeetsingh]

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

[#5]

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.

[anjali0108]

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.

[jonathandienst]

>>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).

[Digvijay_Singh]

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.