Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XML Mapping Issues
I am fairly new to mapping XML into an excel spreadsheet, and I need some
help to make the spreadsheet behave the way I want. I receive an xml file from an outside application that is in this format: <?xml version"1.0"? <Master <Header <HeaderInfo...</HeaderInfo </Header <Record <Reference type="A"a1</Reference <Reference type="B"b1</Reference </Record <Record <Reference type="A"a2</Reference </Record <Record <Reference type="A"a3</Reference <Reference type="B"b3</Reference </Record </Master Basically, there isn't always a Reference Type "B". I want to map these into excel into two columns, like: a1 b1 a2 a3 b3 What I did is set up two source maps, mapped one using type="A" into one column, and type="B" into the other. Unfortunately, I get this: a1 b1 a2 b3 a3 Is there a way to have the map pull a blank if there is no Type B entry, instead of skipping over it? This is probably pretty rudimentary, but I can't figure it out. Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapping one table based on another table range | Excel Worksheet Functions | |||
character mapping | Excel Discussion (Misc queries) | |||
character mapping | Excel Discussion (Misc queries) | |||
Suggestions for creating Issues Log using Excel? | Excel Worksheet Functions | |||
Anyone know where I can get a basic market mapping template? | Excel Discussion (Misc queries) |