Split one column to unknown number of columns

[AbiJeev]

I want to split a column based on double pipe (||) delimiter and load it into excelfile, and my output column number varies .can anyone help me to achieve this , I tried dynamic in textractdelimited but that is not supported .Am using Talend real time big data 7.3.1 version

I want to have one value in one column in excel

Thank you

[Anonymous]

Hi

What about tExtractDynamicField which is available in all subscription-based Talend products.

Can you show us an example data to explain your requirement?

Regards

Shong

[AbiJeev]

There are many rows in a table and am.itrrating one by one .In that row am having a varchar type snowflake where ​am storing many records. Single column with many records . So am using tfixedflow after iteration , then tNormalize to split the rows and to split columns which is unknown is where am struck and after splitting columns I have to put into excel. Then for next iteration I have to apend in next sheet

E.g

Column1

Aa||34||der

Bb||35||and

The above 2 records are in single row and a column. Like stored the entire file in single column