* Table is not in cache of opened tables, so open it.
Code: Select all
Change From: Open HashTable
Change To: OpenPath HashTable
Arg1 = Full Hash file path
Arg2= Key
Arg3= column position to return.
Moderators: chulett, rschirm, roy
* Table is not in cache of opened tables, so open it.
Code: Select all
Change From: Open HashTable
Change To: OpenPath HashTable
It is tough to explain in the example I have given above, lets assume that the 'select' selection will be in a different column derivation............ShaneMuir wrote:But how are limiting the output?
Each time in your examples, you are only showing one output but you have said that its possible the constricting value could be 'source' or 'select' or many others. How are you determining which value the output is to be restricted by? Ie Are you only ever wanting one output or are you wanting more than one?
Arg2 if you harcode the Arg2 it will only return output of one column, otherwise you have to use ((Arg1, Arg2, Arg3) or (Arg1, Arg2, Arg3) or (Arg1, Arg2, Arg3)....................)it will be a very big onetalk2shaanc wrote:Or if you want to avoid adding the hash file to VOC. Make a copy of UtilityHashLookup and change the command given after comment
* Table is not in cache of opened tables, so open it.You are now good to go, no hasle of adding the hash file to VOC.Code: Select all
Change From: Open HashTable Change To: OpenPath HashTable
Arg1 = Full Hash file path
Arg2= Key
Arg3= column position to return.
Well the more you tell us, the more we may be able to help.prasad111 wrote:It is tough to explain in the example I have given above, lets assume that the 'select' selection will be in a different column derivation............ShaneMuir wrote:But how are limiting the output?
Each time in your examples, you are only showing one output but you have said that its possible the constricting value could be 'source' or 'select' or many others. How are you determining which value the output is to be restricted by? Ie Are you only ever wanting one output or are you wanting more than one?