topic Re: XML file data input, modification and uotput in Talend Studio

XML file data input, modification and uotput

Anonymous — Thu, 21 Nov 2019 04:16:49 GMT

Suppose an organization pays their employees on a monthly basis. The salary of each
of its employees is tallied in an XML file for each month. According to the new requirements, the
new software must perform following things:
a) If an employee is not present during a month award them zero salaries.
b) If a particular month is not present in the salary XML file, award zero salaries
for that as well.

Re: XML file data input, modification and uotput

Anonymous — Thu, 21 Nov 2019 05:22:55 GMT

Do you want to generate a new XML file? What are you expected result? Can you show us an example output based on your input file?

Regards
Shong

Re: XML file data input, modification and uotput

Anonymous — Thu, 21 Nov 2019 06:12:09 GMT

Hi Shong,

I want to generate XML file with added data.

XML file attached with the post(Once again attached to this post). Sample is as below. In below file there are only 6 months for employee. I want add remaining months(Total 12 months) and add zero salary to those months.

<Employees>
<EMP_NAME1>K</EMP_NAME1>
<Employee>
<EMP_ID>101</EMP_ID>
<EMP_NAME>Henry Mark</EMP_NAME>
<EMP_PROJECT_ID>P123</EMP_PROJECT_ID>
<SALARY>

EmployeeSalary.xml

Re: XML file data input, modification and uotput

Anonymous — Wed, 27 Nov 2019 08:17:47 GMT

See below scenario, it creates a new XML file based on your input example XML file, it adds new monthly salary element and set salary as 0 if it is not found in the source file.

Hope it helps and let me know if you have any questions.

Regards

Shong

new_employee_salary.xml