topic generic schema - set a field as enum in Talend Studio

generic schema - set a field as enum

Anonymous — Sat, 16 Nov 2024 12:19:35 GMT

Hi
In a generic schema, I need to set a field as an Enum (as named in MySQL).
A simple example :
Field named ANSWER : Enum("Yes","No","No answer")
About the little story, I have to integrate XLS files into an Oracle database and I use tSchemaComplianceCheck components to check the compatibility between the schemas
It works for field's type comparaison but I want to check the values too for the fields typed as Enum. But I don't know how to set this kind of field type.
Thanks by advance

Re: generic schema - set a field as enum

Anonymous — Thu, 22 Mar 2012 07:18:01 GMT

Hi
Talend does't support Enum type as data type on schema, you can define it as a string with delimiter, such as:
"Yes;No;No answer", and then parse the string or filter it on Java components, like tJavaRow or tMap.
Best regards
Shong

Re: generic schema - set a field as enum

Anonymous — Thu, 22 Mar 2012 12:45:41 GMT

Ok. I'll try this. Thank you
So, what is the List type?

Re: generic schema - set a field as enum

Anonymous — Sun, 15 Dec 2019 14:09:48 GMT

Were you able to solve this? If yes, can you please explain me this in detail?