Creating custom component with dynamic schema

Four Stars

Creating custom component with dynamic schema

Hello,

 

I'm trying to create a custom component with a dynamic schema definition .

I want for example to load my schema columns from an excel document.

Is this possible?

 

Thanks

Moderator

Re: Creating custom component with dynamic schema

Hello,

Are you going to create an input excel component with dynamic schema?

Here are some existed custom components for tFileExcel-component on talend exchange portal.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

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.
Four Stars

Re: Creating custom component with dynamic schema

Thanks xdshi,

I'm not creating an input excel component.

I want to create an output component that have a predifined schema dynamically loaded from external source (excel,xml, db..) based on some field.

Thanks

Four Stars

Conditional schema in custom component not working

Hi,

I'm building a custom component that have a dynamic schema based on field value.

My XML descriptor file look like this:

 

		<PARAMETER NAME="INPUT_SCHEMA" FIELD="SCHEMA_TYPE" REQUIRED="true"
			NUM_ROW="40" READONLY="true" SHOW_IF="SEVERITY == 'ERROR'">
			<TABLE READONLY="true" >
				<COLUMN NAME="error" TYPE="id_String" READONLY="true" />
				<COLUMN NAME="cause" TYPE="id_String" READONLY="true" />
			</TABLE>
		</PARAMETER>
		
		<PARAMETER NAME="INPUT_SCHEMA" FIELD="SCHEMA_TYPE" REQUIRED="true"
			NUM_ROW="41" READONLY="true" SHOW_IF="SEVERITY == 'INFO'">
			<TABLE READONLY="true" >
				<COLUMN NAME="info" TYPE="id_String" READONLY="true" />
			</TABLE>
			
		</PARAMETER>

The problem is that regardless the SEVERITY field value,I'm always getting the first schema fields.

Any help please?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.