topic Re: Format XML structure in Talend Studio

Format XML structure

Alpha549 — Sat, 16 Nov 2024 06:50:58 GMT

Hello everyone !

Here is a test job :

And the tFixedFlowInput configuration :

The tXML_Map configuration :

I get this XML string :

<?xml version="1.0" encoding="UTF-8"?>
<students>
	<student>
		<name>A</name>
		<stat>15</stat>
	</student>
	<student>
		<name>B</name>
		<stat>13</stat>
	</student>
	<student>
		<name>A</name>
		<stat>13</stat>
	</student>
	<student>
		<name>A</name>
		<stat>17</stat>
	</student>
	<student>
		<name>B</name>
		<stat>14</stat>
	</student>
	<student>
		<name>C</name>
		<stat>12</stat>
	</student>
</students>

I wonder if it's possible to "aggregate" values and get rather this XML string :

<?xml version="1.0" encoding="UTF-8"?>
<students>
	<student>
		<name>A</name>
		<stat>15</stat>
		<stat>13</stat>
		<stat>17</stat>
	</student>
	<student>
		<name>B</name>
		<stat>13</stat>
		<stat>14</stat>
	</student>
	<student>
		<name>C</name>
		<stat>12</stat>
	</student>
</students>

This structure would be kind of difficult to read because here a student could have an infinity of stats, I'm aware of that, BUT, just by curiosity, I would like to know if it's possible to generate XML like this ?

Thanks !

Re: Format XML structure

Tech8 — Wed, 16 Jan 2019 07:52:50 GMT

Could you try adding in the tXMLMap (out1) the loop to the stat tag instead of the student tag? I didnt tested it so im not sure if this will work in your case.

Re: Format XML structure

tjohn — Wed, 16 Jan 2019 12:36:54 GMT

Hello,

give a try to this : put an aggregate on name and loop on stat

Thanks and regards

tjclearner

Re: Format XML structure

Alpha549 — Wed, 16 Jan 2019 13:56:46 GMT

Hello,

When I only set stat as loop I get :

<?xml version="1.0" encoding="UTF-8"?>
<students>
	<student>
		<name>A</name>
		<stat>15</stat>
		<stat>13</stat>
		<stat>13</stat>
		<stat>17</stat>
		<stat>14</stat>
		<stat>12</stat>
	</student>
</students>

I couldn't create a group on name so I tried to create a loop on stat and then a group on student.

I get this XML file :

<?xml version="1.0" encoding="UTF-8"?>
<students>
	<student>
		<name>A</name>
		<stat>15</stat>
	</student>
	<student>
		<name>B</name>
		<stat>13</stat>
	</student>
	<student>
		<name>A</name>
		<stat>13</stat>
		<stat>17</stat>
	</student>
	<student>
		<name>B</name>
		<stat>14</stat>
	</student>
	<student>
		<name>C</name>
		<stat>12</stat>
	</student>
</students>

Almost ! 😕

Re: Format XML structure

tjohn — Wed, 16 Jan 2019 14:03:59 GMT

hello,

why not use first a tsortrow then :

put an aggregate on name

and loop on stat

Thanks

Re: Format XML structure

Tech8 — Wed, 16 Jan 2019 14:57:53 GMT

Try setting up the "All in one" option as true and run the job again. This with my example because if you are using aggregate you have to set it as false (check this aswell).

Re: Format XML structure

Alpha549 — Wed, 16 Jan 2019 16:02:20 GMT

Using tSortRow + student as group + stat as loop I get this :

<?xml version="1.0" encoding="UTF-8"?>
<students>
	<student>
		<name>A</name>
		<stat>13</stat>
		<stat>15</stat>
		<stat>17</stat>
	</student>
	<student>
		<name>B</name>
		<stat>13</stat>
		<stat>14</stat>
	</student>
	<student>
		<name>C</name>
		<stat>12</stat>
	</student>
</students>

That's nice !

It's clear that the work would be more difficult if there are sub elements in stat, with loops...

Thank you for your help !

I think that

Re: Format XML structure

tjohn — Wed, 16 Jan 2019 16:12:53 GMT

Nice
put it as resolved.
Thanks