DSXchange

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

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=

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

Regards,
Munish

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

Better mark this one as resolved, too!

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