All Questions
207
questions
0
votes
1
answer
40
views
XSLT to split XML based on value of node
I'd like to split a XML based on a value of a node via XSLT 3.0 transformation.
<SalesOrderRequestRequest>
<SalesOrderRequest>
<ProcessingTypeCode>ZO03</ProcessingTypeCode>
...
0
votes
1
answer
254
views
Dynamically map XML elements to JSON fields in C#
I have an XML document, and I also have a mapping configuration that specifies how to map XML elements to JSON fields. The XML structure and the mapping can change, and I need a way to dynamically ...
0
votes
0
answers
79
views
Excel sheet to be mapped to XML Source schema file and then exported via VBA
After tirelessly searching countless pages and sites I need some assistance with converting an excel file into a XML file.
The manual process is as follows:
Excel sheet provided with data
Developer ...
0
votes
0
answers
158
views
XML to SQL Server mappings program
In summary, I am trying to write a .NET program that allows the user to load in an XML file and a SQL Server database to then create mappings (for later use) between the XML nodes of the file and the ...
1
vote
1
answer
625
views
INFORMATICA POWERCENTER: Mapping issue and XML output
I'm a beginner with Powercenter, and I want to convert a relation output result into a xml file.
I have a xsd file with the xml structure.
When I import it into Designer, PWC create automatically the ...
0
votes
2
answers
295
views
possible options for Cell Mapping in Google Sheet
I have a Google sheet, has two worksheets with cell "A1" as drop down:
Completed
Not Completed
Show All
I want to link both cells so that change in value of one cell will depict in other ...
0
votes
1
answer
483
views
XML export in Excel fails: XML table is bound to a different XML map
Initial situation
An existing Excel document with several sheets including formulas and VisualBasic macros.
Steps to reproduce
A new sheet was added with a simple table (1 row, some columns) to be ...
0
votes
1
answer
516
views
is it possible to do xml to json transformation in JOLT
Is it possible to do XML to JSON transformation on https://jolt-demo.appspot.com/#inception. Like pass XML input and write spec in JSON and get JSON output. If yes, is there any documentation or any ...
0
votes
0
answers
166
views
Map soap response to object
I have this problem for 3 days. He gets the following response from the server
<?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/...
0
votes
3
answers
361
views
How to get dynamic columns and map Row Values to Column Header with XSLT 1.0
I got a XML and need to create the below showed Table.
As you can see, the Result in the Row needs to mapp the Column Header.
And those Header Columns are dynamic (depending on the provided Time-...
1
vote
2
answers
185
views
XML Mapping is not workiing - C#
I am working in project for fun where, I have to deserialize my XML below:
<?xml version="1.0" encoding="utf-8"?>
<Remote Created="2022-09-13T09:45:05" Version=&...
0
votes
2
answers
723
views
SQL COUNT DISTINCT with CASE : How do i subquery without using exists?
context:
In SQL Server have a big XLSX file that i am mapping to an XML file. A column called 'referentie' gets different values each time. I need to count unique values and display a code accordingly ...
1
vote
1
answer
381
views
How do I retrieve the string value of XmlEnum "Name"?
I am new to XmlEnum property. I am working on a project written in C#. I have an enum class and I wanted to map each enum to a string value. So, for example, one of the enums is:
public enum MyEnum
{
...
0
votes
1
answer
80
views
Get list of Dates and map values based on Day XSLT2.0/XSLT3.0
I have this scenario wherein:
Need to list the dates between the Start Date and End Date and based on Type being 'Weekly' or 'Bi-Weekly' need to map the Day Nodes (Monday,Tuesday...) to the ...
0
votes
0
answers
147
views
new to XML to Excel mapping (or Access)-want to save and reuse map
I am new to XML and Excel mapping, and/or Access and transform files. I am very proficient with VBA in both Excel and Access.
Monthly XML files are received, 6 of them at this time but this will ...