https://community.qlik.com/t5/Talend-Studio/How-to-get-the-schema-from-an-Excel-file/m-p/2248689#M33466 Hi <BR />If the file contains column name, create a Excel file metadata and retrieve the column name automatically under Metadata node in Repository. Refer to this documentation. <BR /> <A href="https://help.talend.com/reader/TQ2GKCAZ5tvBI38XVYT1ZA/2jqKsz4wl9XOb0xiRVYvgA" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/TQ2GKCAZ5tvBI38XVYT1ZA/2jqKsz4wl9XOb0xiRVYvgA</A> <BR /> <BR />Regards <BR />Shong Fri, 13 Mar 2020 09:02:09 GMT Anonymous 2020-03-13T09:02:09Z https://community.qlik.com/t5/Talend-Studio/How-to-get-the-schema-from-an-Excel-file/m-p/2248688#M33465 <P>I'm now testing to load of an Excel file with more than 30 columns.</P> <P>Is there any way to get the schema automatically without having to add and rename every single column? thanks</P> Sat, 16 Nov 2024 02:59:41 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-the-schema-from-an-Excel-file/m-p/2248688#M33465 MaxIT 2024-11-16T02:59:41Z https://community.qlik.com/t5/Talend-Studio/How-to-get-the-schema-from-an-Excel-file/m-p/2248689#M33466 Hi <BR />If the file contains column name, create a Excel file metadata and retrieve the column name automatically under Metadata node in Repository. Refer to this documentation. <BR /> <A href="https://help.talend.com/reader/TQ2GKCAZ5tvBI38XVYT1ZA/2jqKsz4wl9XOb0xiRVYvgA" target="_blank" rel="nofollow noopener noreferrer">https://help.talend.com/reader/TQ2GKCAZ5tvBI38XVYT1ZA/2jqKsz4wl9XOb0xiRVYvgA</A> <BR /> <BR />Regards <BR />Shong Fri, 13 Mar 2020 09:02:09 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-the-schema-from-an-Excel-file/m-p/2248689#M33466 Anonymous 2020-03-13T09:02:09Z