Filtering Look Up Table

[Munish]

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

[sudeepmantri]

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

[kumar_s]

I guess the requirement is same as your other post. viewtopic.php?t=106337&highlight=

[Munish]

Hi Sandeep and Kumar,
Thanks for your advices.
It is the same requirement as in my other post.

Regards,
Munish

[kumar_s]

So is it you got the solution or expecting something else. If yes, you can close the post.

[ray.wurlod]

Better mark this one as resolved, too!

[Munish]

Hi Ray and Kumar,
Thanks for your support.
Closing the job.
Regards,
Munish