Processing dynamic schema in Talend.

[Niyojita]

Is there any way to process an excel file with no fix schema in Talend's Data Integration free version?

[manodwhb]

@not specified not specified​ , we do not has a component to do this may you can try to check in Talend Exchange or you can develop and upload to talend exchange.

https://exchange.talend.com/

Thanks,

Manohar

[Niyojita]

I tried developing but not achieving the desired result.

Can you please suggest some way to develop?

Thank you!

[tnewbie]

Niyojita,

Single worksheet of an Excel file can always be treated and opened as an ',' delimiter file. Unless you have multiple worksheets within an Excel file you can comfortably treat your excel as a comma delimited file and still go the Dynamic datatype route. Not sure if I am missing something here.

[Niyojita]

I am not sure if the Dynamic route is available in the freely available version of Talend.