topic Access field values from already loaded table in QlikView https://community.qlik.com/t5/QlikView/Access-field-values-from-already-loaded-table/m-p/151061#M28975 <HTML><HEAD></HEAD><BODY><P>Hi Arun,</P><P>load your CityField name twice in both tables like:</P><P>MasterData:</P><P>Load</P><P>CityName</P><P>CityName as CityNameMaster</P><P>....</P><P>Transaction:</P><P>Load</P><P>CityName</P><P>CityName as CityNameTrans</P><P>Now you can select possible or excluded values in the listboxes.</P><P>If you want only have transaction data for CityNames in your Master Date than use:</P><P>Transaction:</P><P>Load</P><P>CityName,</P><P>....</P><P>From ...</P><P>Where Exists (CityName);</P><P>as example.</P><P>Good luck!</P><P>Rainer</P><P></P><P></P></BODY></HTML> Wed, 05 Aug 2009 14:59:25 GMT 2009-08-05T14:59:25Z Access field values from already loaded table https://community.qlik.com/t5/QlikView/Access-field-values-from-already-loaded-table/m-p/151060#M28974 <HTML><HEAD></HEAD><BODY><DIV>Hi Team,</DIV><DIV></DIV><DIV>How can i access fields from the table that is already loaded in qv?</DIV><DIV></DIV><DIV>Actually, I have loaded my Master.xls file that contain only one column viz. City with city names in it.</DIV><DIV></DIV><DIV>After that, I am loading transaction records from other xl file.</DIV><DIV></DIV><DIV>For every transaction record, i want to check wheter City name in transaction record is appearing anywhere in my Master.xls?</DIV><DIV></DIV><DIV>How can i do that?</DIV><DIV></DIV><DIV>Pls Suggest!!</DIV><DIV></DIV></BODY></HTML> Wed, 05 Aug 2009 14:07:54 GMT https://community.qlik.com/t5/QlikView/Access-field-values-from-already-loaded-table/m-p/151060#M28974 2009-08-05T14:07:54Z Access field values from already loaded table https://community.qlik.com/t5/QlikView/Access-field-values-from-already-loaded-table/m-p/151061#M28975 <HTML><HEAD></HEAD><BODY><P>Hi Arun,</P><P>load your CityField name twice in both tables like:</P><P>MasterData:</P><P>Load</P><P>CityName</P><P>CityName as CityNameMaster</P><P>....</P><P>Transaction:</P><P>Load</P><P>CityName</P><P>CityName as CityNameTrans</P><P>Now you can select possible or excluded values in the listboxes.</P><P>If you want only have transaction data for CityNames in your Master Date than use:</P><P>Transaction:</P><P>Load</P><P>CityName,</P><P>....</P><P>From ...</P><P>Where Exists (CityName);</P><P>as example.</P><P>Good luck!</P><P>Rainer</P><P></P><P></P></BODY></HTML> Wed, 05 Aug 2009 14:59:25 GMT https://community.qlik.com/t5/QlikView/Access-field-values-from-already-loaded-table/m-p/151061#M28975 2009-08-05T14:59:25Z