topic Re: Solution in QlikView

Solution

nagarjuna_kotha — Tue, 08 Sep 2015 09:29:34 GMT

Hi all ,

I m facing with one issue, i.e

See below data.

Table1:

Load Tic_No,

CallDate,

Branch,

Division,

Region

From ,,,,,,,,

Table 2:

Load Tic_No,

MobleNo,

Base_Id

From,,,,,,

Table 3:

Load Base_Id,

Address

from,,,,,,,,,

What i want is, i want MobleNo and Address in table 1 with same Tic_No Count for All Div , region and branch.

I did Like this:

Table1:

Load Tic_No,

CallDate,

Branch,

Division,

Region

From ,,,,,,,,

Left Join

Load Tic_No,

MobleNo,

Base_Id

From,,,,,,

Table 3:

Load Base_Id,

Address

from,,,,,,,,,

But its Not working.Please Give me some valid solutions.

Re: Solution

gautik92 — Tue, 08 Sep 2015 09:30:30 GMT

did yu try applymap()

Re: Solution

nagarjuna_kotha — Tue, 08 Sep 2015 09:32:19 GMT

In my way its working But Count is mismatching

No ,Can u tell me How to do ?

Re: Solution

jagan — Tue, 08 Sep 2015 09:34:44 GMT

Hi,

Can you attach sample data so that it would be easier to provide the solution? If Tick_No are same in both the tables then you can get the expected results. Also instead of joining just keep the tables as such so that it will join based on the Key field.

Regards,

Jagan.

Re: Solution

sasiparupudi1 — Tue, 08 Sep 2015 09:35:29 GMT

Try

Table1:

Load Tic_No,

CallDate,

Branch,

Division,

Region

From ,,,,,,,,

Left Join(Table1)

Load Tic_No,

MobleNo,

Base_Id

From,,,,,,

Join(Table1)

Load Base_Id,

Address

from,,,,,,,,,

hth

Sasi

Re: Solution

jagan — Tue, 08 Sep 2015 09:35:41 GMT

Hi,

I think the records are duplicating when you join the tables, so don't join the tables using Join, just load the tables and try.

Regards,

Jagan.

Re: Solution

gautik92 — Tue, 08 Sep 2015 09:37:10 GMT

Did yu try lik this

MapMobNo:

Mapping

Load Tic_No,

MobleNo

from...

MapAddr:

Mapping

Load Tic_No,

Address

from...

Table1:

Load Tic_No,

Applymap('MapMobNo',Tic_No) as MobNo,

Applymap('MapAddr',Tic_No) as Address,

CallDate,

Branch,

Division,

Region

From ,,,,,,,,

Re: Solution

nagarjuna_kotha — Tue, 08 Sep 2015 09:38:00 GMT

if i do as it is its giving more records.

Re: Solution

jagan — Tue, 08 Sep 2015 09:40:09 GMT

Can you share the sample file and your expected result?

Regards,

Jagan.

Re: Solution

nagarjuna_kotha — Tue, 08 Sep 2015 09:41:48 GMT

Gowtham In address Table i dont have Tic_No.Base_Id is Comman for Table 2 Base_Id

Re: Solution

gautik92 — Tue, 08 Sep 2015 09:43:30 GMT

can yu post the qvw appl?

Re: Solution

sasiparupudi1 — Tue, 08 Sep 2015 09:49:39 GMT

may be try group by

Table1:

Load Tic_No,

CallDate,

Branch,

Division,

Region

From ,,,,,,,,

Left Join(Table1)

Load Tic_No,

MobleNo,

Base_Id

From,,,,,,

Join(Table1)

Load Base_Id,

concat( Address,',')

from,,,,,,,,,

group by Base_Id

;

hth

Sasi