Join issue

[manu1512]

Hi All,

In the snapshot there are two tables linked with one common key.

In table Tw_Sp_bo there is one field TW_SP_BO.Reservoir Pressure.There is corresponding of TW_SP_BO.Reservoir Pressure. for every field %KEY_DATE in other table TW.

Now i want a single table consisting of only these two fields and there value should be corresponding.

[manu1512]

vishsaggi‌ again pls help

[vishsaggi]

Need more information.

"Now i want a single table consisting of only these two fields and there value should be corresponding."

Can you explain a little more for this above highlighted.

[manu1512]

vishsaggi i mean how to form a single table consisiting of these  two fields only....i tried by using left join and residnet load but values are missing...

[vishsaggi]

You have to use concatenate to get all values from two tables.

[manu1512]

Join will not work??

[MK9885]

Maybe try Outer Join with taking your Key from both tables?

[vishsaggi]

Can you show me how you are joining a screen shot of your script?

[manu1512]

Hi Vish,

I am trying this,.

Temp:

Load %KEY_DATE,

%KEY_TW

Resident TW;

left join(Temp)

LOAD

%KEY_TW,

TW_SP_BO.Reservoir_Pressure

Resident TW_SP_BO;

DROP TABLE TW,TW_SP_BO;

[vishsaggi]

Did you try this?

Temp:

Load %KEY_DATE,

     %KEY_TW

Resident TW;

//Join(Temp)

Concatenate(Temp)

LOAD

%KEY_TW,

TW_SP_BO.Reservoir_Pressure

Resident TW_SP_BO;

DROP TABLE TW,TW_SP_BO;

Uncomment Join (As Khan suggested) and comment Concatenate and try.