topic Re: How to quickly add multiple columns in tMap in Talend Studio

How to quickly add multiple columns in tMap

JM39 — Sat, 16 Nov 2024 02:15:59 GMT

Hello.

My output file needs to have 155 columns & I think I've figured out how to create the output schema based on a metadata file.

But I can't figure out an easy way of getting those 155 columns into my tMap without having to manually add them and name each one. Is it possible to do that?

Re: How to quickly add multiple columns in tMap

manodwhb — Tue, 02 Jun 2020 12:12:30 GMT

@JM39, if you have the output file or table by using which you can create a Generic schemas in metadata and which you can choose in tmap of output section Schema type >>Reposity and can choose the generic schema which you created.

Re: How to quickly add multiple columns in tMap

Anonymous — Tue, 02 Jun 2020 12:17:25 GMT

Hi
If you have saved the schema as a XML file, then you can import the schema from the XML file, otherwise, you have to add column manually one by one, and click 'Auto map' button to create the mapping if the column name in input table is the same as the column name in output table, or drag and drop the columns from input table to output table.

Regards
Shong