topic Re: How to combine two fields from two different table in QlikView

How to combine two fields from two different table

Tue, 09 May 2017 08:42:06 GMT

Hi Every one,

I have two tables Like T1, T2. These two tables contains same fields but different values i.e.,

Ex:

AND

So, i need to use T1 table values in T2.

My question is how to use T1 values in T2 Table?

Re: How to combine two fields from two different table

Anil_Babu_Samineni — Tue, 09 May 2017 08:44:55 GMT

May be alias name for second table then use T1 as where you need

Re: How to combine two fields from two different table

MindaugasBacius — Tue, 09 May 2017 09:35:48 GMT

Applymap or Join might work.

Re: How to combine two fields from two different table

avinashelite — Tue, 09 May 2017 09:39:27 GMT

Since the values are different in both the columns better to concatenate both the table columns are to alias as the same column names

Re: How to combine two fields from two different table

PrashantSangle — Tue, 09 May 2017 09:40:13 GMT

Hello,

What is your required output??

concatenate or outer join will work for you..

Regards,

Prashant

Re: How to combine two fields from two different table

Tue, 09 May 2017 11:36:12 GMT

Hi,

In my requirement is in that two table i haven't mention ID. Actually in that two tables one common ID column is there, I am using. Qualify and Unqualify. Why because as per my requirement i need to use first table T1 table and creating sum values, and by using T2 table also. So I need to use two files for different requirements. In this situation I need to use T1 table value i.e A value use in T2.

So how to use A value in T2 table

EX:

Qualify *;

Unqualify Id;

Load T1

Load T2

Re: How to combine two fields from two different table

PrashantSangle — Tue, 09 May 2017 11:42:30 GMT

Hi,

sorry to say but still not clear can you explain with sample data??

Regards

Re: How to combine two fields from two different table

avinashelite — Tue, 09 May 2017 11:56:23 GMT

Better to share the sample data ,QVW and the required output so that it will helps to understand

Re: How to combine two fields from two different table

Wed, 10 May 2017 04:40:35 GMT

FYI,

Table 1 is:

Table 2 is:

Re: How to combine two fields from two different table

PrashantSangle — Wed, 10 May 2017 05:10:32 GMT

also post your required output.

Regards,

Re: How to combine two fields from two different table

avinashelite — Wed, 10 May 2017 05:28:12 GMT

as per your data their is no common key between the tables so better to concatenate both the tables

Re: How to combine two fields from two different table

Wed, 10 May 2017 06:12:55 GMT

Hi,

I have tried to concatenate, after that the coming values are not correct

Re: How to combine two fields from two different table

PrashantSangle — Wed, 10 May 2017 06:19:58 GMT

What is your required output???

You can use outer join also.

What are the issues you are facing with concatenate.

Regards,

Prashant Sangle

Re: How to combine two fields from two different table

avinashelite — Wed, 10 May 2017 06:21:55 GMT

Could you share the sample output what is required so that we could help you

Re: How to combine two fields from two different table

Wed, 10 May 2017 11:37:24 GMT

Hi,

There are two tables Table 1 and Table 2. both table fields are same but values are different.

suppose by using Table 1, i am create some values. As well as By using Table 2 i have to create some values, So in this situation in Table 2 i want to use Table 1 values.

Now my problem is when i am taking Table 1 fields in Table 2 it is not associated. Its disable..

So could you please tell me how to mapping with these two tables..?

Re: How to combine two fields from two different table

avinashelite — Wed, 10 May 2017 11:44:55 GMT

Yes , it won't be because you don't have the common key !! so how can you except to get a values from table 1 in table 2 ? in order to get that we should have a common key between both the tables otherwise it will not get the right data

Hope this answers your question