topic Re: Join issue in QlikView

Join issue

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Join issue

manu1512 — Fri, 08 Dec 2017 16:15:11 GMT

vishsaggi‌ again pls help

Re: Join issue

vishsaggi — Fri, 08 Dec 2017 16:17:52 GMT

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.

Re: Join issue

manu1512 — Fri, 08 Dec 2017 16:19:52 GMT

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

Re: Join issue

vishsaggi — Fri, 08 Dec 2017 16:32:32 GMT

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

Re: Join issue

manu1512 — Fri, 08 Dec 2017 16:34:32 GMT

Join will not work??

Re: Join issue

MK9885 — Fri, 08 Dec 2017 16:38:57 GMT

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

Re: Join issue

vishsaggi — Fri, 08 Dec 2017 16:44:32 GMT

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

Re: Join issue

manu1512 — Fri, 08 Dec 2017 16:51:34 GMT

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;

Re: Join issue

vishsaggi — Fri, 08 Dec 2017 17:08:39 GMT

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.

Re: Join issue

manu1512 — Fri, 08 Dec 2017 17:56:01 GMT

Let me try...this