How to pass array as input parameter to tDBSP component?.

NNayal1600240775 — Fri, 15 Nov 2024 21:40:28 GMT

My Talend flow looks like:

tFixedFlowInput:

tDBSP:

In the schema of TDBSP - I have set the datatype of IN_LIST as "Object" . As when I set the datatype as "List" I was getting compile errors.

Also in tDBSP Parameter I have tried both ways setting up the Custom Type as "Array" or "STRUCT".

In both the cases I am getting Invalid column type.

Exception in component tDBSP_1

My IN_LIST is an array that looks like:

[123456789, 123, CAU123, 30000123, 30000123, DO, 12, , MONTH]

topic How to pass array as input parameter to tDBSP component?. in Talend Studio