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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog