This is my first attempt to do anything with Qlik
i Can't seem to load the section
"<Id type="EN">3165141024289</Id>"
This is my code ,iart is uniek , but so i need to join somehow.
Thanks for any help
Article:
LOAD
[iart],
text([artgrp]) as artgrp,
[Id] as Artnr,
"Id/type=EN" as Ean ,
[POP],
[TecDoc] as Tecdoc_Partno,
[TecDoc/supplier] as Dlnr,
[MakerCode/Maker] as Brandname,
[MakerCode/Family] as xcode,
[Descriptions/Desc] as PartDescription
FROM [lib://QLIKDATA/XML/ARTEXP.xml]
(XmlSimple, table is [ProductExport/Products/Product]);
/*<?xml version="1.0"?>
<ProductExport>
<Firma code="02">BLA</Firma>
<Products>
<Product iart="00165310"
artgrp="001">
<Id type="SA">0 986 487 002</Id>
<Id type="EN">3165141024289</Id>
<MakerCode type="GOLDA">
<Maker>BOSCH</Maker>
<Family>1511</Family>
</MakerCode>
<TecDoc supplier="0030">0 986 487 002</TecDoc>
<Descriptions>
<Desc lang="NL">REMSCHOENEN BS402</Desc>
</Descriptions>
<POP>00 </POP>
<SalesUnit>1</SalesUnit>
<PackingUnit ctype="DOOS">1</PackingUnit>
<PriceUnit ptype="STUK">1</PriceUnit>
<Prices>
<Price type="BR"
country="NL"
val="EUR"
date="20240627">26,80</Price>
</Prices>
<Catalog country="NL">0</Catalog>
</Product>
<Product iart="04164162"
artgrp="001">
<Id type="SA">0 986 487 013</Id>
<Id type="EN">3165143579213</Id>
<MakerCode type="GOLDA">
<Maker>BOSCH</Maker>
<Family>1511</Family>
</MakerCode>
<TecDoc supplier="0030">0 986 487 013</TecDoc>
<Descriptions>
<Desc lang="NL">REMSCHOENEN BS410</Desc>
</Descriptions>
<POP>00 </POP>
<SalesUnit>1</SalesUnit>
<PackingUnit ctype="DOOS">1</PackingUnit>
<PriceUnit ptype="STUK">1</PriceUnit>
<Prices>
<Price type="BR"
country="NL"
val="EUR"
date="20240627">50,70</Price>
</Prices>
</Product>
</Products>
</ProductExport>
