topic Fetch value from database and insert into XML file in Talend Studio

topic Fetch value from database and insert into XML file in Talend Studio https://community.qlik.com/t5/Talend-Studio/Fetch-value-from-database-and-insert-into-XML-file/m-p/2319760#M89969 <P>hello ,</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="talend.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrZ9.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139000iA4190F1DBB15B782/image-size/large?v=v2&px=999" role="button" title="0683p000009LrZ9.png" alt="0683p000009LrZ9.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tt.PNG" style="width: 525px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrZE.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147236iCD1EF80C80687761/image-size/large?v=v2&px=999" role="button" title="0683p000009LrZE.png" alt="0683p000009LrZE.png" /></span></SPAN></P> <P>I want to add data to the "ArrayOfString" tag when setting name = "<SPAN>Communes</SPAN>" and <SPAN>setting name = "ETAT".</SPAN></P> <P><SPAN>for this i defined "ArrayOfString"  element Group and "String" element loop.</SPAN></P> <P>the problem that I always add the data in the first ArrayOfString tag or the setting name = "Groups".</P> <P> </P> <P>the <SPAN>structure of the file xml is : </SPAN></P> <P> </P> <P><SPAN><configuration></SPAN><SPAN><BR /><applicationSettings><BR /><AlerteCIS.My.MySettings><BR /><BR /><setting name="a" serializeAs="String"><BR /><value>a</value><BR /></setting><BR /><setting name="b" serializeAs="String"><BR /><value>b</value><BR /></setting><BR /><setting name="c" serializeAs="String"><BR /><value>c</value><BR /></setting><BR /><BR /><BR /><setting name="Groupes" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>1</string><BR /><string>2</string><BR /><string>3</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /><BR /><setting name="Natures" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>a</string><BR /><string>b</string><BR /><string>c</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /><setting name="Communes" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>a</string><BR /><string>b</string><BR /><string>c</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /><setting name="ETAT" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>a</string><BR /><string>b</string><BR /><string>c</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /></AlerteCIS.My.MySettings><BR /></applicationSettings><BR /></configuration></SPAN></P> Tue, 07 Nov 2017 17:31:52 GMT Anonymous 2017-11-07T17:31:52Z Fetch value from database and insert into XML file https://community.qlik.com/t5/Talend-Studio/Fetch-value-from-database-and-insert-into-XML-file/m-p/2319760#M89969 <P>hello ,</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="talend.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrZ9.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139000iA4190F1DBB15B782/image-size/large?v=v2&px=999" role="button" title="0683p000009LrZ9.png" alt="0683p000009LrZ9.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tt.PNG" style="width: 525px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrZE.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147236iCD1EF80C80687761/image-size/large?v=v2&px=999" role="button" title="0683p000009LrZE.png" alt="0683p000009LrZE.png" /></span></SPAN></P> <P>I want to add data to the "ArrayOfString" tag when setting name = "<SPAN>Communes</SPAN>" and <SPAN>setting name = "ETAT".</SPAN></P> <P><SPAN>for this i defined "ArrayOfString"  element Group and "String" element loop.</SPAN></P> <P>the problem that I always add the data in the first ArrayOfString tag or the setting name = "Groups".</P> <P> </P> <P>the <SPAN>structure of the file xml is : </SPAN></P> <P> </P> <P><SPAN><configuration></SPAN><SPAN><BR /><applicationSettings><BR /><AlerteCIS.My.MySettings><BR /><BR /><setting name="a" serializeAs="String"><BR /><value>a</value><BR /></setting><BR /><setting name="b" serializeAs="String"><BR /><value>b</value><BR /></setting><BR /><setting name="c" serializeAs="String"><BR /><value>c</value><BR /></setting><BR /><BR /><BR /><setting name="Groupes" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>1</string><BR /><string>2</string><BR /><string>3</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /><BR /><setting name="Natures" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>a</string><BR /><string>b</string><BR /><string>c</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /><setting name="Communes" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>a</string><BR /><string>b</string><BR /><string>c</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /><setting name="ETAT" serializeAs="Xml"><BR /><value><BR /><ArrayOfString xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A href="http://www.w3.org/2001/XMLSchema" target="_blank" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A>"><BR /><string>a</string><BR /><string>b</string><BR /><string>c</string><BR /></ArrayOfString><BR /></value><BR /></setting><BR /></AlerteCIS.My.MySettings><BR /></applicationSettings><BR /></configuration></SPAN></P> Tue, 07 Nov 2017 17:31:52 GMT https://community.qlik.com/t5/Talend-Studio/Fetch-value-from-database-and-insert-into-XML-file/m-p/2319760#M89969 Anonymous 2017-11-07T17:31:52Z Re: Fetch value from database and insert into XML file https://community.qlik.com/t5/Talend-Studio/Fetch-value-from-database-and-insert-into-XML-file/m-p/2319761#M89970 Hi <BR />Your input data should contains setting name value so that the string will be inserted to the right group. For example: <BR />Add a new column called setting_name, and set its value as "Communes" on tMap before tAdvancedFileOutputXML. Map this column to @name element on tAdvancedFileOutputXML. <BR /> <BR />Regards <BR />Shong Thu, 16 Nov 2017 08:59:32 GMT https://community.qlik.com/t5/Talend-Studio/Fetch-value-from-database-and-insert-into-XML-file/m-p/2319761#M89970 Anonymous 2017-11-16T08:59:32Z