DSXchange

Can you pls more explain on the process. for first table (ref table) look up key is (partno and d_effectv ). From main table it will be part_no and build_date should be equal to min of d_effectv. You told this is applicable for month only. Actully this ref table is duty rate table and might change t...

Kryt0n wrote:Admittedly their request was as vague as can be managed but think they are trying to do a lookup, not merge columns

no sir..this is a real scenario in manufacturing domain.you have to pickup particular cost from lookup table..what was applicable in that period.

nani1974 wrote:I think you can do this by using Column_Export stage.

How? i think u donot understand the question.

how i can sparse lookup.?.its source is dataset.
yes part no is key. i have to pull out the cost in my target based on condition that the cost is applicable to that period.

input lookup table partno d_eff_date cost 1 10-Jan-12 10 1 10-Mar-12 12 1 10-Jun-12 15 1 15-Jul-12 20 input dataset partno bulid date 1 10-Jan-12 1 11-Jan-12 1 11-Mar-12 output partno bulid date d_eff_date cost shouldbe 1 10-Jan-12 10-Jan-12 10 1 11-Jan-12 10-Jan-12 10 1 11-Mar-12 10-Mar-12 12

Hi Umberto, Your problem can easily solved. 1. proper C++ compiler is not available in your system. 2.Yes it works on WINDOWS XP also.So don't bother about OS of the machine. 3. For compatibility of 7.5 PX you need VS2003 version. Note you have to install VS 2003 in same drive you install DS server....