topic Re: Unqualify a field but do match with other tabel in QlikView

Unqualify a field but do match with other tabel

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

Hi,

I want to match the column name “OrderNo” as “Order” in other table, if I qualify these they are coming up with table name as prefix .is there a way to match the column name??

LOAD

OrderNo,

ShipOptID,

ShipName,

ShipID,

FROM

[C\Qlikview\LIVE\Data\QVD \Ship.QVD](qvd);

Re: Unqualify a field but do match with other tabel

Anil_Babu_Samineni — Fri, 21 Jul 2017 14:56:04 GMT

Why not renaming

LOAD

OrderNo as Order,

ShipOptID,

ShipName,

ShipID,

FROM

[C\Qlikview\LIVE\Data\QVD \Ship.QVD](qvd);

Join

Load Order, .... From QVD;

Re: Unqualify a field but do match with other tabel

madhuqliklondon — Fri, 21 Jul 2017 15:02:26 GMT

Hi Anil,

It is in dashboard ,so giving table names to load , Even the other column "order" was in in table but i have unqualified it.

Re: Unqualify a field but do match with other tabel

Anil_Babu_Samineni — Fri, 21 Jul 2017 15:07:50 GMT

I didn't get that? Can you explain with structure where you do and what you are doing

Re: Unqualify a field but do match with other tabel

madhuqliklondon — Fri, 21 Jul 2017 15:19:27 GMT

Hi Anil,

Unqualify*;

Ship:

LOAD

OrderNo as Order,

ShipOptID,

ShipName,

ShipID,

FROM

will this work?

Re: Unqualify a field but do match with other tabel

madhuqliklondon — Fri, 21 Jul 2017 15:26:05 GMT

Sure Anil,

I will try to get sample .qvw

Re: Unqualify a field but do match with other tabel

madhuqliklondon — Fri, 21 Jul 2017 15:46:58 GMT

Done this now ,

Qualify*;

Unqualify Order ;

Load

OrderNo as Order,

ShipOptID,

ShipName,

ShipID,

FROM [C\Qlikview\LIVE\Data\QVD \Ship.QVD](qvd);

Re: Unqualify a field but do match with other tabel

Anil_Babu_Samineni — Fri, 21 Jul 2017 16:00:31 GMT

You mean to say UNQUALIFY OrderNo ??

Re: Unqualify a field but do match with other tabel

madhuqliklondon — Wed, 26 Jul 2017 10:25:53 GMT

Hi Anil ,yes.