IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Profile: Davy
About
User Name: Davy
Forum Rank: Newbie
Real Name:
Location
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Wednesday, June 23, 2021
Last Visit: Wednesday, June 23, 2021 2:09:36 PM
Number of Posts: 1
[0.01% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: XML to Excel- variable number of columns
Posted: Wednesday, June 23, 2021 2:09:35 PM
Hello everybody

I'm new to Altova Mapforce, and I'm trying to map an xml file to excel.
The problem I'm facing is that I have a number of statusses, which need to map onto columns in the excel file.
However, not every customer uses the same statusses, so the number of columns and the column headers should be dynamic, depending on the customer.
Unfortunately, it seems like I have to define a column range in advance, and add the column header, but there is no way of conditionally adding the column to the excel output or not.

Is there any way that this would be possible, so that I can output the right columns (and only those columns) to the excel file, depending on a customer id?

Thanks in advance!

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.