Is there a component like tmap in Talend with which I can process columns data. I would like for example to capitalize the first letter of the first column or to format the phone numbers or more complex processing?

Data Productivity Cloud
,
1

Is there a component like tmap in Talend with which I can process columns data. I would like for example to capitalize the first letter of the first column or to format the phone numbers or more complex processing ?

2

Hi @barbaracryer58​

Welcome to the Matillion Community, this is a great question, I have raised it with our team and will pop back with an answer after the weekend for you.

Just to confirm you are using Matillion ETL to achieve this?

Kind regards, Joe

3

Hi Joe,

 

I'm using Matillion Designer.

 

Kind regards,

4

It could be great if you add a component where we can process data using python script for example.

5

I don't know ? My Entreprise trial has ended. But I used AWS S3.

6

Thank you,

Which data warehouse are you using please @barbaracryer58​

Thanks Joe

7

Thank you,

 

I will take this away and check with the team if this can be done and the best approach for you, in the meantime if you need anything else, please do let me know.

 

Kind regards, Joe

8

Hello,

 

I appreciate your patience while I obtained some information. As you mentioned, Tmap, there is not currently anything like this in Matillion; the closest component to that functionality is the calculator component.

 

We do have native Python support, including Python pushdown to Snowflake. That is in Orchestration pipelines, not Transformation.

 

I hope that helps, please do let me know if you need anything else.

 

Kind regards, Joe