Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
vishsaggi again pls help
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.
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...
You have to use concatenate to get all values from two tables.
Join will not work??
Maybe try Outer Join with taking your Key from both tables?
Can you show me how you are joining a screen shot of your script?
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;
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.