Creating custom component with dynamic schema

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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?