String to Dynamic Data Type

One Star

String to Dynamic Data Type

Hi,
I am using Talend Enterprise Edition of DI.
Can anyone know how to convert String data type to Dynamic Data Type in tMap?
One Star

Re: String to Dynamic Data Type

Hi
No. You can't simply covert data between String type and Dynamic type.
Dynamic is a feature called dynamic schema in Talend Enterprise Edition.
You can get instructions and scenarios from documents.
Regards,
Pedro
One Star

Re: String to Dynamic Data Type

Hi Pedro,
There is issue in using the Dynamic data type.
The Dynamic data type fixes the First row's delimiter count as default and if the next records consist of more delimiters then its being truncated.
So I am trying to get the input from tFileInputFullRow as string and checking the row count and trying to convert as Dynamic.
There is also issue when try to convert Dynamic data type to string and getting the string count.(It gives different string count)
Is there any solution?
One Star

Re: String to Dynamic Data Type

Hi
If the schema of each row is different from others, you'd better read and loop this file only one row each time.
Regards,
Pedro
One Star

Re: String to Dynamic Data Type

Hi,
I am trying to only allow the records if the delimiter count is matched.

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download