Multiple inputs for tHMap/TDM data mapper?

Highlighted
Four Stars

Multiple inputs for tHMap/TDM data mapper?

I am extracting a number of elements from a complex Excel spreadsheet in a job, which then map these columns to multiple tMap components.   

 

Many of the tMap input columns have a 1:1 relation with the tHMap XML output, with no looping required.  That works fine with a singular tHMap input. 

 

Since my columns are broken across mulitple tMaps (some of which ARE collections of data, and need a simple loop), is there a way to easily have these multiple inputs piped to the tHMap which are then mapped to the singular tHMap XML output?

 

It sounds straightforward on paper.  Can't find an example or a way to do so however.  Thanks!

 

(using Cloud Data Management 7.1.1)

 

Highlighted
Moderator

Re: Multiple inputs for tHMap/TDM data mapper?

Hello,

The feature, tHMap multi-input, is supported in V 7.1.1.

For more information, please refer to this online documentation about:TalendHelpCenter:Input/Output (Multiple Input/Output Documents)

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: Multiple inputs for tHMap/TDM data mapper?

Hi,

 

We have attempted to use the multi-input capabilities of the Data Mapper and have had no luck constructing a usable workflow.

 

Are there good examples of this that does not utilize multiple input files?  We are sourcing our data from an Excel spreadsheet during the job, and extracting into multiple input streams (with varied, mostly unrelated data/schemas and various requirements for looping) before needing to map to the single XML output.  There may be 20+ input streams in a job, potentially as we do our extract. 

 

See the very simplified job design (FixedFlowInputs instead of our) as an example.

 

Thanks!

2019 GARTNER 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

Talend Cloud Developer Series - Introduction

The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform

Watch Now

Talend Cloud Available on Microsoft Azure

An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now