topic Re: RE:Merge in QlikView

RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:02:08 GMT

hi all,

how to merge two tables into one table?

IN BOTH TABLE LVL_ID IS COMMON..

Note: Without using joins

suppose i hve fields lik

Tab1:

lOAD lvl_id,

req_id,

req_name,

req_desc,

req_priority,

create_date,

req_moddate,

create_by,

mod_by,

reqlast_action,

req_status

FROM

[$(vSourceData)\newtable5.qvd]

(qvd);

Table2:

LOAD

lvl_id,

test_id,

test_createon,

test_desc,

test_estmdevtime,

test_lastaction,

test_moddate,

test_name,

test_owner,

test_type,

tc_modifycount,

test_delflag

FROM

[$(vSourceData)\newtable6.qvd]

(qvd);

how can i achive dis/?

Re: RE:Merge

Anonymous — Mon, 14 Dec 2015 08:07:44 GMT

simply try this:

Tab1:

lOAD lvl_id,

req_id,

req_name,

req_desc,

req_priority,

create_date,

req_moddate,

create_by,

mod_by,

reqlast_action,

req_status

FROM

[$(vSourceData)\newtable5.qvd]

(qvd);

inner/Left/Right join(Tab1) //Join based on your requirement, it may be left or right or inner

Table2:

LOAD

lvl_id,

test_id,

test_createon,

test_desc,

test_estmdevtime,

test_lastaction,

test_moddate,

test_name,

test_owner,

test_type,

tc_modifycount,

test_delflag

FROM

[$(vSourceData)\newtable6.qvd]

(qvd);

Re: RE:Merge

its_anandrjs — Mon, 14 Dec 2015 08:07:45 GMT

Simple use concatenate key word also add table flag

Tab1:

lOAD lvl_id,

req_id,

req_name,

req_desc,

req_priority,

create_date,

req_moddate,

create_by,

mod_by,

reqlast_action,

req_status ,

'Table1' as TabFlag

FROM

[$(vSourceData)\newtable5.qvd]

(qvd);

Concatenate(Tab1)

LOAD

lvl_id,

test_id,

test_createon,

test_desc,

test_estmdevtime,

test_lastaction,

test_moddate,

test_name,

test_owner,

test_type,

tc_modifycount,

test_delflag,

'Table1' as TabFlag

FROM

[$(vSourceData)\newtable6.qvd]

(qvd);

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:11:44 GMT

witout using joins...

i need to use two fileds lvl_id and req_id using dis

and table2 use two fileds lvl_id and Test_Id

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:19:54 GMT

thanks anand....can u explain how it wil works?

Re: RE:Merge

tamilarasu — Mon, 14 Dec 2015 08:21:04 GMT

Hi Suresh,

You need to use concatenate statement. Something like below

Tab1:

Load *

From

Data1;

Concatenate(Tab1)

Tab2:

Load *

From

Data2;

Re: RE:Merge

tamilarasu — Mon, 14 Dec 2015 08:23:07 GMT

Check the below link,

Understanding Join, Keep and Concatenate

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:25:45 GMT

is there any way to merge the tables using two fields in a table?

Re: RE:Merge

jagan — Mon, 14 Dec 2015 08:26:25 GMT

Hi Suresh,

If only one field is common in both the tables then Concatenate is not the best choice, you can go for Joins(Left/Right/Inner) depends on your requirement. Join to be done carefully, if there is many to many mapping then the records will be duplicated and numbers may be doubled/tripled.

The best suggestion is not to join, qlikview will join based on the common fields during runtime.

Hope this helps you.

Regards,

jagan.

Re: RE:Merge

its_anandrjs — Mon, 14 Dec 2015 08:29:22 GMT

When you use Concatenate between two tables then you get single table as result and if there is same fields like in your case lvl_id then when you use concatenate you get single field on resultant table. Also if you want to see the values of different table like Table1 >> lvl_id or Table2 >> lvl_id then you can use the TableFlag to see the values.

If in one of the table there is master table or unique values then use JOINS (Inner / Left / Right)

Regards

Anand

Re: RE:Merge

Anonymous — Mon, 14 Dec 2015 08:29:30 GMT

Yes, but make sure both the field should be avail in both the tables and then Composite key of those 2 or 3 or 4 fields will de the rest

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:32:22 GMT

thnx anand...for ur expln.

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:32:52 GMT

thnx all...good info

Re: RE:Merge

buzzy996 — Mon, 14 Dec 2015 08:35:34 GMT

it will simply append 2nd table records/data with ur first table records/data.

means,if we can assume 1'st table is having 10 records and new flag as table1.

2nd table is having 5 records and new flag as table 2.

ur output is:

10 records with flag as table from first table

5 records from 2'nd table with ur flag as table2.

in the above case by mistaken he put flag as Table1 in both the case.

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:37:48 GMT

yes...but i hve 5 tables so i need those 5tables into one single table...

Re: RE:Merge

buzzy996 — Mon, 14 Dec 2015 08:48:14 GMT

yes,u can do..if you want/if it meets ur requirements.

Re: RE:Merge

Chanty4u — Mon, 14 Dec 2015 08:50:30 GMT

yeah...thnx shiva... i got the exact req wit anad reply.....