look up
Moderators: chulett, rschirm, roy
look up
In my job design i have one source(hash file) and 1 lookups( hash file).
When i find a value in lookup as A1 then i need to concatenate the value coming from source with 1 and hook that value
When i find a value in lookup as A2 then i need to concatenate the value coming from source with 2 and hook that value
When i find a value in lookup as A3 then i need to concatenate the value coming from source with 3 and hook that value
source
A
LOOKUP1
A1
A2
A3
..
Any idea.
thanks in advance
When i find a value in lookup as A1 then i need to concatenate the value coming from source with 1 and hook that value
When i find a value in lookup as A2 then i need to concatenate the value coming from source with 2 and hook that value
When i find a value in lookup as A3 then i need to concatenate the value coming from source with 3 and hook that value
source
A
LOOKUP1
A1
A2
A3
..
Any idea.
thanks in advance
satya
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: look up
Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value?
If it has all the values then what should be assigned to the output?
If only one is present in the lookup then here is the way u can handle it --
Create the Hashed file with two columns - One column Substring(Lookup , 1,1) which can be the key column , the second column with the actual value.
When the Value matches it will pull out the actual column.
If it has all the values then what should be assigned to the output?
If only one is present in the lookup then here is the way u can handle it --
Create the Hashed file with two columns - One column Substring(Lookup , 1,1) which can be the key column , the second column with the actual value.
When the Value matches it will pull out the actual column.
need more information
What is the output u want from the job?
As per ur data, there there is 1 rows in source and in the hash file there is matching row.
The basic rule of using hash file as a lookup is that u need to have one key field in it which will match the source(driving table) table's field.
If u elaborate and give some more sample data then some one will be able to give appropriate solution.
As per ur data, there there is 1 rows in source and in the hash file there is matching row.
The basic rule of using hash file as a lookup is that u need to have one key field in it which will match the source(driving table) table's field.
If u elaborate and give some more sample data then some one will be able to give appropriate solution.
Re: look up
if u use Substring(Lookup , 1,1), then as per data provided it will look likeDeepakCorning wrote:Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value?
If it has all the values then what should be assigned to the output?
If only one is present in the lookup then here is the way u can handle it --
Create the Hashed file with two columns - One column Substring(Lookup , 1,1) which can be the key column , the second column with the actual value.
When the Value matches it will pull out the actual column.
A
A
A
..
then how u can make it as key field?
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: look up
Please read "Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value?rafik2k wrote:if u use Substring(Lookup , 1,1), then as per data provided it will look likeDeepakCorning wrote:Are you saying tht the lookup can have A1 , A2 and A3 at the same time? or a single value?
If it has all the values then what should be assigned to the output?
If only one is present in the lookup then here is the way u can handle it --
Create the Hashed file with two columns - One column Substring(Lookup , 1,1) which can be the key column , the second column with the actual value.
When the Value matches it will pull out the actual column.
A
A
A
..
then how u can make it as key field?
If it has all the values then what should be assigned to the output? "
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: