Unqualify a field but do match with other tabel

[madhuqliklondon]

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);

[Anil_Babu_Samineni]

Why not renaming

  LOAD

     OrderNo as Order,

     ShipOptID,

     ShipName,

     ShipID,

     FROM

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

Join

Load Order, .... From QVD;

[madhuqliklondon]

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.

[Anil_Babu_Samineni]

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

[madhuqliklondon]

Hi Anil,

Unqualify*; 

   Ship:

   LOAD

     OrderNo as Order, 

     ShipOptID,

     ShipName,

     ShipID,

     FROM

will this work?

[madhuqliklondon]

Sure Anil,

I will try to get sample .qvw

[madhuqliklondon · Accepted solution]

Done this now ,

Qualify*;

Unqualify Order ;

Load

OrderNo as Order,

     ShipOptID,

     ShipName,

     ShipID,

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

[Anil_Babu_Samineni]

You mean to say UNQUALIFY OrderNo ??

[madhuqliklondon]

Hi Anil ,yes.