topic Re: Dynamic Mapping in tmap via variables in Talend Studio

Dynamic Mapping in tmap via variables

Anonymous — Wed, 05 Sep 2018 05:41:58 GMT

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

Re: Dynamic Mapping in tmap via variables

fdenis — Wed, 05 Sep 2018 08:24:17 GMT

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

Re: Dynamic Mapping in tmap via variables

Anonymous — Wed, 05 Sep 2018 08:39:27 GMT

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

Re: Dynamic Mapping in tmap via variables

fdenis — Wed, 05 Sep 2018 09:08:04 GMT

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!