Hi, I have a scenario where I have to map column members from input to output. I.e.
|ABC (Source_Column)||ABC1 (Target_Column)|
|Billed||To be Billed|
|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!
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.
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.
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.
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 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.
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.
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!
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"?
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
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.