I have the below XML show the Account and all associated products bucket under it,
<ASExport>
<Account>
<Identifier>
<AccountID>14555</AccountID>
<Status>0</Status>
</Identifier>
<Identifier>
<ProductID>8SSE</ProductID>
<Status>0</Status>
</Identifier>
<Identifier>
<ProductID>G34H</ProductID>
<Status>0</Status>
</Identifier>
<Bucket>
<ID>3065</ID>
<Type>1</Type>
</Bucket>
</Account>
<Account>
<Identifier>
<AccountID>455</AccountID>
<Status>0</Status>
</Identifier>
<Identifier>
<ProductID>333</ProductID>
<Status>0</Status>
</Identifier>
<Identifier>
<ProductID>222</ProductID>
<Status>0</Status>
</Identifier>
</Account>
</ASExport>
Problem: the account come in the same level of product, and the result coming like this:
Accountid ProductID
14555 Null
Null 8SSE
Null G34H
455 Null
Null 333
Null 222
but the result should be like this:
Accountid ProductID
14555 8SSE
14555 G34H
455 333
455 222
question from:
https://stackoverflow.com/questions/65871412/the-xml-master-tag-come-in-the-same-level-of-the-other-tag 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…