topic Re: How to map column members in Talend in Talend Studio

How to map column members in Talend

Anonymous — Sun, 15 Apr 2018 22:02:57 GMT

Hi, I have a scenario where I have to map column members from input to output. I.e.

ABC (Source_Column)	ABC1 (Target_Column)
Plan	Actual Plan
Billed	To be Billed
	Waived
To Be Billed	To Be Billed

So what I mean is, for my ABC column if the member is "Plan", in the ABC1, the member should be called as "Actual Plan". If 'Billed', then in ABC1 as To be billed etc. How can I do it..? Is there any good link/tutorial that goes over how to build this logic. Pls help, thanks!

Re: How to map column members in Talend

ashok5 — Mon, 16 Apr 2018 02:59:40 GMT

It's very simple
1) Define your source schema on the left hand side
2) Define your target schema on the right hand side
3) simply drag and drop your source column on to your target column you wanted to map.
Please refer to the below tutorial

https://youtu.be/bOxUdictbgc

Note: please do remember spaces are not allowed in the column name while defining the schema anywhere in talend
Thanks
Ashok

Re: How to map column members in Talend

Anonymous — Mon, 16 Apr 2018 03:08:43 GMT

Hi Ashokvv,

Thank you for the reply. However I'm not asking for normal column to column mapping. That I understand and I have done it.

However, I am asking if my column ABC, has members likes Plan, Billed etc and I want to output the column, but rename the members there i.e. plan changes to 'actual plan', billed to 'to be pilled' etc how do I change it.

Re: How to map column members in Talend

ashok5 — Mon, 16 Apr 2018 03:30:22 GMT

Hi kanT

yes I am referring to the same, you can rename the column on the target schema, click on any column name in the schema editor

Please see the attached image highlighted in yellow.

thanks

Ashok

tMap Column Rename.JPG

Re: How to map column members in Talend

Anonymous — Mon, 16 Apr 2018 03:42:27 GMT

Hi Ashokvv,

It is not about renaming the column but renaming the members inside that column.

I.e. Column ABC, has 3 members. I have to rename these 3 members in target.

Re: How to map column members in Talend

ashok5 — Mon, 16 Apr 2018 04:04:10 GMT

Hi KanT

You can not rename a source column name (column member) inside the target column if you do so you will loose the mapping between source and target. Perhaps you can map a different source column(s) to that target column. To do that go to mapping editor of the target column, PFA image.

thanks

Ashok

tMap Mapping editor.JPG

Re: How to map column members in Talend

Anonymous — Mon, 16 Apr 2018 04:16:10 GMT

Thanks your response. But by doing this, I am still changing the column name not the name of members inside that column. Pls correct me if I m wrong.

Re: How to map column members in Talend

Anonymous — Mon, 16 Apr 2018 06:47:29 GMT

Hi Kant,

I think you want to change target value based on source value. If it is then import attached talend job.

I have created routine for this.

job_Change_Value_In_Target.zip

Re: How to map column members in Talend

Anonymous — Tue, 17 Apr 2018 00:13:26 GMT

Hi Ravi,

I am very new to talend. Can u please let me know how to import this job in talend. I went to File-> Import-> and select General and selected this folder.and clicked ok.but nothing got populated. can u pls list the steps. Thanks!

Re: How to map column members in Talend

Anonymous — Tue, 17 Apr 2018 19:26:56 GMT

Hi Ravi,

I was able to import that job in Talend.

I see you created a tfixedinput_1 column and put the members values in it. But where did u do the mapping to say that Plan maps to Actual Plan, billed to "to be billed"?

Re: How to map column members in Talend

vboppudi — Tue, 17 Apr 2018 20:19:54 GMT

Hi KanT,

You can try below approach to get desired output.

in tMap: for Target column logic will be

row2.Details == null || row2.Details=="" ? "Waived":row2.Details.equals("Plan")?"Actual Plan":row2.Details.equals("Billed")?"To be Billed":row2.Details

Regards,