576 questions
1
vote
1
answer
72
views
XSLT for-each with using last and aggregation
I am not sure if this is possible with XSLT but I am trying to get the below XML into a format where it is name, title, date (if same date then only get date once), last value of In time (might not be ...
- 29
0
votes
1
answer
76
views
xslt code to split the xml file in to mulitple xml files in runtime based on xml tag <events> and <id>
Am trying to split the xml file in to multiple xml files based on the xml tag / in the input xml file. the individual output xml files should go in sequence as per the input xml /from top to bottom of ...
- 21
0
votes
1
answer
145
views
XSLT convert date and time from PST to UTC
In my XSLT, I'm outputting a time stamp:
<time_stamp>
<xsl:value-of select="format-dateTime(wd:Last_Functionally_Updated, '[M01]/[D01]/[Y0001] [H01]:[m01]:[s01]')"/>
</...
- 25
1
vote
1
answer
49
views
XSLT Trying to exclude certain records using xsl:if but not working
I'm new to xslt, I'm working with below XML
<?xml version='1.0' encoding='UTF-8'?>
<wd:Report_Data xmlns:wd="urn:com.workday.report/INT0194_Recruitics">
<wd:Report_Entry&...
- 25
1
vote
1
answer
71
views
XSLT Group by using 3 different elements from different node level
I'm new to XSLT, for the below XML, I'm trying to implement this transformation logic: If <wd:candidate>,<wd:CF_LRV_Requisition_ID> and <wd:Stage> have the same combination of values,...
- 25
0
votes
1
answer
64
views
XSLT generating only output when no strings are matched
Here’s a snippet of my XSLT code:
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
...
0
votes
2
answers
55
views
XSLT : Create a new xml/csv structure
I'd like to ask for your guidance to better achieve the desired output. I have an XSLT file that I don't have control on it and I'd like to apply a transformation that modify the initial structure.
My ...
- 505
1
vote
1
answer
87
views
Sum values in nested groupings in XSLT
I'm trying to do nested grouping in XSLT 1.0 and am facing some issues, below is my XML sample code.
<?xml version="1.0" encoding="iso-8859-1"?>
<INVOICE>
<GROUP ...
1
vote
2
answers
80
views
XSLT : Apply an xml tranformation followed by another text tranformation
Even though there are several threads that explain the use of multiple templates in the same xslt file, I can't find a solution to address my issue.
I would like to apply two transformations to my xml ...
- 505
0
votes
1
answer
105
views
XSLT : Sum and remove xml nodes based on conditions
I'm currently working on a tricky transformation in which I need to sum the amount of the game articles price value when the article appears twice and to exclude the second article from the output.
...
- 505
0
votes
1
answer
68
views
How to concatenate XML field in different node, if a key field is common between them?
My source xml file has elements in this form:
<Employees>
<Employee>
<Name>ABC</Name>
<City>Delhi</Delhi>
</Employee>
<Employee>
<Name>ABC</...
- 13
0
votes
1
answer
76
views
XSLT Variable assigning for each incremental delimiter position from the input XML
For the Input XML:
<EmpJob>
<EmpJob>
<ConcatDepartment>+Local_Functions+Group_Functions+Group_Owners+Group_Managers+Group_Leads+Interim_Services</ConcatDepartment>
...
0
votes
1
answer
48
views
XSLT Variable assigning for each delimiter position from the input XML
In my XSLT I need to assign the values to the variable named FODepartment_LX where X represents the position of the delimiter(+) starting from the leftmost delimiter and Maximum position is 10. If the ...
0
votes
0
answers
66
views
XSLT issue with the concatenation when empty fields
Requirement is to create a CSV file out of an XML for each Employee Records. Each record in CSV contains multiple lines which depends on the department level which I have achieved it through the ...
0
votes
1
answer
56
views
XSLT 2.0 Transformation: Grouping nodes by value and elements
Trying to transform xml and group nodes by value and elements in xslt 2.0
I have got an input xml as below:
<?xml version='1.0' encoding='UTF-8'?>
<Applications>
<Application>
...
0
votes
1
answer
122
views
XSLT 3.0 Transformation
Trying to transform xml and group nodes by value and elements in xslt 3.0
Hey Guys, I have got an input xml as below
<?xml version='1.0' encoding='UTF-8'?>
<Applications>
<...
2
votes
1
answer
36
views
How do I restructure this block of XML?
Okay, so what's been handed to me is this block of nodes that's the result of a transformation from Word to XML that I have no control over. The next step for this will be a transformation to HTML. ...
0
votes
1
answer
92
views
key grouping on similar items XSLT1.0
I need to group Itemno for different Level
Example:
Level1:8000000377 - 1
8000000376 - 1
8000000378 - 2
8000000373 - 1
8000000371 - 1
Level2:8000000373 - 2
<Root>
...
- 45
0
votes
1
answer
2k
views
BI Publisher - How to get rows to repeat in a table w/ dynamic column on RTF template
I have a table where I am pivoting the data in the last column by accounting date as (ACCOUNTING_DATE) and a debit from one of the subledger tables as (UNROUNDED_ACCOUNTED_DR).
I found an old tutorial ...
- 21
0
votes
1
answer
87
views
XSLT Grouping for version 2.0
would like to know how to go about creating multiple groupings in XSLT. The following XML should be grouped by memberID, deposit date, and deposit type. The total amount for each member should be ...
- 5
0
votes
1
answer
88
views
XSLT Multiple Grouping
would like to know how to go about creating multiple groupings in XSLT. The following XML should be grouped by memberID, deposit date, and deposit type. The total amount for each member should be ...
- 5
0
votes
1
answer
79
views
XSLT duplicating dependent data from XML
I am facing issue with the xslt transformation from xml.
Xml: The node "<wd:GPAR_LRV_Dependents_group>" is repeated 12 times in xml and the business object to extract dependent ...
- 1
0
votes
1
answer
68
views
Need help to list the values in Array using xslt
Need help to list the values in Array using xslt. Currently, they are showing as one row by another and need the values to show them in array.
Attached is the source xml and xslt tried but not sure ...
- 67
0
votes
0
answers
62
views
XSLT transformation with role if find the same tag namepf
I'm working on an XSLT transformation and need assistance in achieving a specific transformation logic. Below are the details:
Objective:
If the <namepf> tag is the same for different <record&...
- 189
0
votes
2
answers
80
views
Grouping only some items in a series
I have an XML document that has a series of paragraphs:
<section>
<title>Section title</title>
<p style="Body">...</p>
<p style="Body"&...
- 2,187
1
vote
2
answers
103
views
Using XSLT to merge/concatenate adjacent tags that share an attribute value, without losing child tags
I have XHTML content in which adjacent anchor tags with the same href value are present and need to be merged. I've been trying to figure out a way to do this with an XSL template and have run into a ...
- 15
0
votes
2
answers
201
views
How to read the specific fields from the XML payload, where this payload is coming again in the field of the main XML payload
Need help to read the XML payload which is coming inside one of the field.
Request Payload:
<?xml version="1.0" encoding="UTF-8"?>
<Code xmlns:ns0="http://example....
- 3
0
votes
1
answer
20
views
Nodes with Comma Separated List. Get Distinct Values and Create New Nodes
I need to create an xml output that groups all the wd:External_Value_Data/wd:Text fields with each distinct Internal Value.
<wd:root>
...
0
votes
2
answers
68
views
Add position numbers if rule from another node applies, but in the order of current node
Input:
<ROOT>
<TEMPLATE style="test">
<ATTRIBUTE name="Color"><VALUE><UNIT>B</UNIT><UNIT>lack</UNIT></VALUE></...
- 3
0
votes
2
answers
119
views
Nested/ multi-level grouping xslt
I have the below xml which I need to first group-by Requester and then for each group I need to have another group-by based on Item exists or not.
<root>
<row>
<Requester>Tim</...
- 67
0
votes
1
answer
78
views
XSLT to group and remove duplicate at same time
Below is my input XML. I want to group below XML based on username and also remove any duplicate in HierarchyLocation
Below is my input XML
<data>
<UploadUser>
<User>
<...
0
votes
1
answer
74
views
Xsl 1.0 to xsl 3.0 conversion issue
xsl 1.0 version :
<xsl:element name="CategoryCodes">
<xsl:copy-of select="attribute::*" />
<xsl:for-each select="GuestRoomInfo"...
0
votes
2
answers
74
views
xslt 2/3 nested group with for-each-group maintaining input order
There are similar questions on stackoverflow but the answers sort or group the matching items putting them out of sequence compared to the order of the input.
I have the following data
<doc>
<...
- 59
0
votes
1
answer
101
views
XML Sum Function
I am trying to create a sum based on equal IDs in an XSLT file and output it in an extra attribute. Maybe one of you can help me?
The followed XML is an output:
<?xml version="1.0" ...
- 3
0
votes
1
answer
59
views
Output available content from Grouped elements using XSLT 2.0
Following the solution provided to this post (credits to: Martin Honnen) where I needed to group the elements in the XML by the id and counting the duplicates based on some rules.
Now I'm having an ...
- 2,819
0
votes
1
answer
30
views
XSLT 1.0 multiple record to single record
Below is my requirement ,
Input XML :
<ns0:TestDTM xmlns:ns0="http://SchemaIN">
<ID>1234</ID>
<Ref>A1</Ref>
<Detail>
<Qualifier>Q1</...
- 133
0
votes
1
answer
188
views
Using XSLT to Group Data Based on Substrings
I am trying to use XSLT to group data from an XML document into two categories. Specifically, given a list of three items, I want the XSLT to export the three items as two different groups (food & ...
- 15
-1
votes
1
answer
38
views
XSLT grouping creation for sequence of elements with specfied condition
I'm new for xslt i need to transform the xml to xml with grouping
My input is here below in that i need to group introduction related information that all are have to group with box element, and i ...
1
vote
1
answer
82
views
Compare element values in a array and fetch the biggest value elements inside the Parent element
I am trying to create a XSLT in 1.0.PLease find below a sample xml. The requirement is to get the biggest value1 field from all 3 and display the tags inside them.
Request XML:
<?xml version="...
- 13
0
votes
1
answer
73
views
Compare the files with key/ID node and generate the output if difference are in Sibling nodes
I want to compare the XML nodes (Key/ID node), and they see if the their sibling node has any different value, then fetch in output.
Input XML where two XML files are merged
<?xml version="1.0&...
- 3
0
votes
0
answers
76
views
xslt using group by function
I need to sum the amount (wd:Amount) if the ContributionType (wd:ContributionType/@wd:Descriptor) is the same by SSN.
Below example, I am expecting the record to be shown:
D|123-45-6789|20230315|2023|...
- 67
0
votes
0
answers
65
views
How to normalize/transform the XML data using xslt
I am new to XSLT and Need help in transforming the data to show:
Need to order the skill ascending by Employee ID and show the data like attached screenshot.
If we have 20 skills, all 20 skills ...
- 67
0
votes
1
answer
72
views
XSLT - Merge same ID elements and get non blank values from same group
Using XSLT 1.0 I need to transform below XML by merging same ID elements and get the non blank values from same ID group and any non present element in one of those same ID group. I did a ...
- 2,819
1
vote
1
answer
63
views
Problem with multiple groups while transforming XML using XSLT
I had a problem with grouping while transforming xml to xml using xslt version 1.0
@michael.hor257k has kindly provided the solution to fix it. Link below:
Problem transforming XML groups with XSLT
...
- 15
0
votes
1
answer
79
views
Problem transforming XML groups with XSLT
I am having problem with grouping while transforming xml to xml using xslt. I found out where the problem comes from but still don't know how to fix it.
I am unable to fetch the group name/multiple ...
- 15
0
votes
1
answer
79
views
match first item in a list but also include in full list
I'm seeking to match the first item in a list but also include the first item in a full list without calling the first item template
given an xml file:
<page>
<set>
&...
- 356
0
votes
1
answer
77
views
Group consecutive numbers in XSLT
How to handle the below type of scenario using XSLT?
Example 1:
Input: <cross-refs>[5, 6, 7, 8, 9]</cross-refs>
Excepted output: <cross-refs>[5-9]</cross-refs>
Example 2:
Input:...
- 17
0
votes
1
answer
50
views
XSLT reorder and check if is empty
I was wording how I could reorder the tag Rice:
Move the tag <Rice>long-grain</Rice> to down and ***<Rice>123</Rice>*** to up;
Remove the third tag <Rice> or remove it ...
- 189
1
vote
1
answer
67
views
Need XSLT Splitter for each record
Please note that source xml fieldscome in sequence means one student's info then another student info.
Can you help on the XSLT to break xml as one group node for each student
My Input is Below
<?...
- 11
0
votes
1
answer
74
views
XSLT 2.0 HOW TO PRINT SAME LINE multiple time based on concat column dates
Assume following record is in xml
EmpNo name enrollingDates
123 abc 10/01/2022-10/02/2022-10/05/2022
Currently reocrd is coming in one line even when dates are different in enrollingdates column
We ...
- 1