This function outputs one or more columns of XML. You can transform the XML to HTML, which is easier to view—see Reports.
The following is an example of the output table created by Factor Analysis.
partid | mfactors | modelstatus | xmlmodel |
---|---|---|---|
1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
The following is an example of the Factor Analysis output table with groupby option.
gender | marital_status | partid | mfactors | modelstatus | xmlmodel |
---|---|---|---|---|---|
F | 3 | 1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
F | 4 | 1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
M | 4 | 1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
F | 2 | 1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
M | 1 | 1 | 1 | FAILED | <?xml version="1.0" encoding="UTF-8"… |
M | 2 | 1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
F | 1 | 1 | 1 | FAILED | <?xml version="1.0" encoding="UTF-8"… |
M | 3 | 1 | 1 | SUCCEEDED | <?xml version="1.0" encoding="UTF-8"… |
To extract the XML in the xmlmodel column into a viewable format, run the following query:
SELECT XMLSERIALIZE(Content X.Dot) as XMLText FROM (SELECT * FROM "outputdatabase"."outputtablename") AS C, XMLTable ( '//*' PASSING CREATEXML(C.XmlModel) ) AS X ("Dot");