Importing XML by xpath

[sbrown]

Hi again Xcalar,

When I import my XML data, I can choose many xpaths for the specific data I want, or fewer lower order xpaths. What's the best practice here?

Sarah

[mprince]

Hi @sbrown,

Because Xcalar Design parses XML elegantly into JSON, you only need to select the main data type for your table using an xml xpath. Once in Xcalar Design, you can double-click on any object column or the DATA column within your table to open the data browser. Using the data browser, you can extract individual fields contained within it, or all fields within the object.

So, by specifying only the xpath for the main data type, you get access to all data within that data object.

Give it a shot and let me know how it goes! I'm glad to answer any additional questions about this.

Take care,
Mark

[sbrown]

Thanks again, Mark. Will do.