Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i tried to only load the first item, so i get 25.01, 26.01 ..... but i did not manage it
Example:
Here my load so far:
1. Table1:
2. Load
3. item%Table as Head
4. From xmlfile.txt (XmlSimple, Table is [Envelope/Body/getReportDataResponse/Array/item/analysisData/item])
5. Where arrayType='xsd:anyType[1]';
Does anyone have an idea?
The wizard shows problems by reading the file - therefore I suggest to adjust the file respectively the source from them:
- Marcus
Hello Marcus,
Thanks for your reply! I do not have the problem with reading the file, it is more to get the right data.
I would like to load the first item of the array, but my where clause isnt the right one. i
I know i could use "Where xsi:type='xsd:string';" but if there are two strings in the array it wouldnt work.
Maybe you could do your filtering in a following load. That meant to load at first the complete xml per wizard and then see how the structures look like. Otherwise you need to provide a complete xml-file.
- Marcus
Hello Marcus,
i looked the structure of my xml-file up but couldnt find anything for filtering.
I attached the xml-file to my post, maybe you find something uesfull.
I'm not a specialist with xml but I have some doubts that the xml-structure is properly built. I could not find a table-relation between this field and the fields in the parent-tables. This meant you couldn't load a field and filter on a different table in one step - you need at least a join between them. Very helpful is further to use the table-wizard to see how looked the xml on table- and field-level respectively in xml and it creates automatically keys between the tables.
Nevertheless you could use this to extract the dates whereby you will need a further field as key to make sense of them:
Load item%Table as Head
From [..\..\..\..\xmlTest.xml] (XmlSimple, Table is [Envelope/Body/getReportDataResponse/Array/item/analysisData/item/item])
Where isnum(item%Table) and len(item%Table) = 10;
Maybe others with more xml experience could take a look on this.
- Marcus