Hi Everybody,
Wishing you all a very happy new year.
My datasource is a dataset (DS1) created by previous job.
I need to add an extra columns and pass on this as new dataset (DS2)
(DS1 + new column)
This new column is the one which I want to get from Lookup table.
I have no column to lookup in DS1 against Lookup Table.
My lookup table have keys and CD for ChargeTypes.
I need to append my DS1 with the Key value from Lookup Table.
Could any one help me with that.
Thanks and regards,
Munish
Filtering Look Up Table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54
- Joined: Wed Oct 25, 2006 11:07 pm
- Location: Hyderabad
Re: Filtering Look Up Table
Hi, What I understand is u need to add one more column to the intermediate dataset, that column is a key field in your reference table n u dont have anything to make lookup. If this is ur problem, try out this. After ur intermediate dataset, add a column generator to generate a dummy integer value of 1( by setting it's initial value as 1 and increament by 0). Select from the reference table the column u wish to add say x and 1. Query-- select x,1 as dummy from table name. MAke the lookup on this dummy field. as the refernce and souce both have 1, all the record will have a match. Then u can propagate the key column and the rest of the field from the input dataset. Hence the diagram will be--------- Dataset->Col. generator->Lookup->dataset
I guess the requirement is same as your other post. viewtopic.php?t=106337&highlight=
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: