Dynamic Mapping in tmap via variables

[Anonymous]

Hi,

I am trying to map dynamically using variables , attaching my design please help.

i want to call the value in row1 into a variable. Is this possible?

Thanks in Adv,

Hachi

[fdenis]

Var value are set for each row.
are you looking for a lookup into the same table?

[Anonymous]

i have requirement where i need to insert one table data into another .. suppose the columns in first table are a,b,c and destination is d,e,f. the mapping varies from month to month.. in january i would like to map a to d in february a should be mapped to e .. So i will have a look up file to give info about changing mappings. is there any other way to do it .
Please help

[fdenis]

if you have multiple mapping you may have multiple TMap and dynamically switch.

if type of mapping is into the row. You can switch on multiple output (and merge them) or implement your logical into TMap (use Var and Inline If (condition)?yes:no)

If you di not ready know your logic you can add lookup on a file who define mapping.
Good luck!