Need Help On how to get the Desired result

[Pali]

Hi All, I need help

I am a beginner to the this talend tool, currently using Talen open studio 7.3.1.

I have a Source xlsx file data as shown below,

this job has two sub jobs.

1. insert data into the TargetTable1(Code, Status, Data) and

2. Split and Map

Country and Location values and insert in to

the

TargetTable2 (Code, Country, Location)

Destination Tables

Job1. Using tMap component I am able to extract

required

data and insert in to TargetTable1

(Code, Status, Data)

Job2. But using the same source xlsx data, I am unable to

Map Country and Location comma separated values to the TargetTable2 (Code, Country, Location)

as shown below :

Using tNormalize component I am able to extract the comma separated

values for

Country/Location but

I need help in Mapping its comma separated values so that I can insert the values in to the TargetTable2.

Have a Nice day.

Thank You in Advance..

[manodwhb]

@Palaksha K S​ ,check tMap and tNormalizer components you can achive.

Thanks,

Manohar

[Pali]

@Manohar B​  Manohar,

Thank You for the reply,

Using tMap, tNormalize, tMMSSqlInput and tDenormalize I am able to validate the Country and Location comma separated values with its respective DB table values.

The above Shared source file is the one after applying validations.

Now using this validated source file I need to extract and Map the data as shown in the TargetTable2.

Tried using tMap, tNormalize, tFilter, tMMSSqlInput and tDenromalze but no result.

Please let me know if you have any specific inputs or solutions ..

Thanks & Regards

Pali