Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
did yu try applymap()
In my way its working But Count is mismatching
No ,Can u tell me How to do ?
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.
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
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.
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 ,,,,,,,,
if i do as it is its giving more records.
Can you share the sample file and your expected result?
Regards,
Jagan.
Gowtham In address Table i dont have Tic_No.Base_Id is Comman for Table 2 Base_Id