XML - Find Schema & Structure

HenpetsGordres1

Hello,

If I have an XML file is there any way to output the structure and column names held within, but not the data. For example, in the following:

I would like my final output to appear as:

CATALOG.CD.TITLE
CATALOG.CD.ARTIST
CATALOG.CD.COUNTRY
CATALOG.CD.COMPANY
CATALOG.CD.PRICE
CATALOG.CD.YEAR

I have attached the sample XML File and also my attempt to date, although it may not be the best way to approach the issue.

Many thanks.

StructureExtractTest.yxmd

Developer Tools

Parse

Accepted answers

Hi @HenpetsGordres1 ,

This was a nice challenge!

Think this does it. (see attached)

Regards,

Tom

All comments

Hi @HenpetsGordres1 ,

This was a nice challenge!

Think this does it. (see attached)

Regards,

Tom

HenpetsGordres1

Hi Tom,

Many thanks for your response, I'm receiving the following error when running the worflow:

Would you have any idea on how to fix?

Thanks!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703