https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200927#M3232 Hi,<BR /><BR />that I have done, but at the end I only have 1 schema for the excell-sheet.<BR />I don't see any possibility to add another one afterwards.<BR /> Wed, 27 Feb 2019 10:48:07 GMT somersst 2019-02-27T10:48:07Z https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200925#M3230 <P>I want to add my Excell-sheet to metadata.</P><P>When I go to the wizard it only creates 1 Schema. Is it possible to create a schema per sheet (with different info) you have in your excell?</P> Wed, 27 Feb 2019 10:09:56 GMT https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200925#M3230 somersst 2019-02-27T10:09:56Z https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200926#M3231 <P>You can create different metadata for different sheet&nbsp;</P><P>&nbsp;</P><P>There is an option to select the sheet while creating metadata</P> Wed, 27 Feb 2019 10:31:06 GMT https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200926#M3231 akumar2301 2019-02-27T10:31:06Z https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200927#M3232 Hi,<BR /><BR />that I have done, but at the end I only have 1 schema for the excell-sheet.<BR />I don't see any possibility to add another one afterwards.<BR /> Wed, 27 Feb 2019 10:48:07 GMT https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200927#M3232 somersst 2019-02-27T10:48:07Z https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200928#M3233 <P>I guess you are overwriting an existing schema with the new worksheet structure.</P><P>&nbsp;</P><P>Try to give them different names.</P><P>Eg. Create new excel metadata as sheet1 --&gt; select the worksheet that you want</P><P>Duplicate that metadata as sheet2 --&gt; edit it to select the worksheet you want for the next one and so on...</P><P>&nbsp;</P><P>Confirm if this works.</P><P>&nbsp;</P><P>I for example had one sheet with country names and one with state names in the same excel file &amp; was able to create 2 metadata schema(s).</P> Wed, 27 Feb 2019 19:50:55 GMT https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200928#M3233 Anonymous 2019-02-27T19:50:55Z https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200929#M3234 <P>So you have to create multiple metadata for 1 single Excell-sheet?</P><P>It's not that you can have the behaviour like for a DB-connection, where you can have 1 metadata for the DB-connection, and multiple schema's for the different tables?</P> Tue, 05 Mar 2019 11:10:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200929#M3234 somersst 2019-03-05T11:10:10Z https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200930#M3235 <P>That is correct.</P> <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LOgrAAG">@somersst</A>&nbsp;wrote: <BR /> <P>So you have to create multiple metadata for 1 single Excell-sheet?</P> <P>It's not that you can have the behaviour like for a DB-connection, where you can have 1 metadata for the DB-connection, and multiple schema's for the different tables?</P> <HR /> </BLOCKQUOTE> <P>&nbsp;</P> Wed, 06 Mar 2019 21:15:33 GMT https://community.qlik.com/t5/Talend-Studio/How-to-define-multiple-schema-s-for-Excell-sheet-with-multiple/m-p/2200930#M3235 Anonymous 2019-03-06T21:15:33Z