How to transform a list of numbers into seperate elements talend tmap-CodePudding

Home > front end > How to transform a list of numbers into seperate elements talend tmap

How to transform a list of numbers into seperate elements talend tmap

Time：07-15

I have a list of codes for each state as an input stored in a table.

What I want as output is this , using tmap transformations

This is the job I made but it doesn't seem to work correctly like I want. The output should have 1000 rows. Does anybody know how to solve this?

CodePudding user response：

One way to do this is to convert your list to a string of comma-separated values (using tConvertType for instance) and then use tNormalize to split this string into individual rows.

Page link：https//www.codepudding.com/frontend/476658.html

Prev:how to convert string data(from input form) to integer data(to db)? Laravel 8

Next:Laravel query with date range and orWhere returns wrong results

Tags：

database

talend

tmap

data-integration

Links：
CodePudding