topic Re: From csv to xml file in Talend Studio

From csv to xml file

rubenfasilva — Fri, 15 Nov 2024 22:19:23 GMT

Hello

I have simple job to do, maybe it's very simple, but I am not able to get it.

I want to transform a csv file into xml.

tflieInputdelimited -> tmap -> tadvancedfileoutputxml.

My csv is:

sku:warehouse;qty

a;ny;2

b;ca;3

c;la;1

I am having this output:

<body>

</product>

</product>

</product>

</products>

</body>

But I want this output

<body>

</product>

</products>

</body>

Is this possbile?

Re: From csv to xml file

Anonymous — Tue, 29 Nov 2022 07:38:11 GMT

Hello @Ruben Silva ,

It's impossible to do that by using tAdvancedFileOutputXML component.

To achieve your goal, it need to do additional steps to read the xml root content as string then replace "</product>

<product>" as empty like the below

output_row.xml= input_row.xml.replaceAll("<\\/product>\\s+<product>","");

Re: From csv to xml file

rubenfasilva — Wed, 07 Dec 2022 09:46:41 GMT

Thank you for you answer.

In the meantime, the team is asking for a json file with an array of details like this:

[

{

"sku" : "A",

"warehouse" : "NY",

"qty" : 2

{

"sku" : "B",

"warehouse" : "CA",

"qty" : 3

{

"sku" : "C",

"warehouse" : "LA",

"qty" : 1

}

]

I never worked with json files before, can you show me steps?

Thank you!