topic Creating custom component with dynamic schema in Talend Studio

Creating custom component with dynamic schema

Anonymous — Mon, 27 Nov 2017 20:51:30 GMT

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

Re: Creating custom component with dynamic schema

Anonymous — Tue, 28 Nov 2017 10:26:52 GMT

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%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F2739

Best regards

Sabrina

Re: Creating custom component with dynamic schema

Anonymous — Tue, 28 Nov 2017 15:41:57 GMT

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

Re: Creating custom component with dynamic schema

Anonymous — Tue, 28 Nov 2017 17:28:37 GMT

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?