Change data types of multiple columns at once?

Six Stars

Change data types of multiple columns at once?

Hello, I have a data set with around 50 columns and in the metadata, the columns are read as string where as i want it as a double. Is there any effective way where i can change them all at once instead of selecting each and every column and then individually changing their data type?

Six Stars

Re: Change data types of multiple columns at once?

Hi,

 

This may help you

tconvertype.PNG

 

Pierre

Six Stars

Re: Change data types of multiple columns at once?

I think you misunderstood the question. Even with the help of this tool, i should get the dropdown of all my 50 columns. Is there an alternative of select all then change data types to double.
Six Stars

Re: Change data types of multiple columns at once?

tconvertypecoche.PNG

Do you mean this checkbox is not helpfull?

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch