Solution

[nagarjuna_kotha]

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.

[gautik92]

did yu try applymap()

[nagarjuna_kotha]

In my way its working But Count is mismatching

No ,Can u tell me How to do ?

[jagan]

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.

[sasiparupudi1]

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

[jagan]

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.

[gautik92]

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 ,,,,,,,,

[nagarjuna_kotha]

if i do as it is its giving more records.

[jagan]

Can you share the sample file and your expected result?

Regards,

Jagan.

[nagarjuna_kotha]

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