Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Done this now ,
Qualify*;
Unqualify Order ;
Load
OrderNo as Order,
ShipOptID,
ShipName,
ShipID,
FROM [C\Qlikview\LIVE\Data\QVD \Ship.QVD](qvd);
Why not renaming
LOAD
OrderNo as Order,
ShipOptID,
ShipName,
ShipID,
FROM
[C\Qlikview\LIVE\Data\QVD \Ship.QVD](qvd);
Join
Load Order, .... From QVD;
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.
I didn't get that? Can you explain with structure where you do and what you are doing
Hi Anil,
Unqualify*;
Ship:
LOAD
OrderNo as Order,
ShipOptID,
ShipName,
ShipID,
FROM
will this work?
Sure Anil,
I will try to get sample .qvw
Done this now ,
Qualify*;
Unqualify Order ;
Load
OrderNo as Order,
ShipOptID,
ShipName,
ShipID,
FROM [C\Qlikview\LIVE\Data\QVD \Ship.QVD](qvd);
You mean to say UNQUALIFY OrderNo ??
Hi Anil ,yes.