PowerQuery: get data from two sources (of the same dimensions)

[deLockloire]

Hi,

I need to create a table from a bank statement. The statement can be downloaded in XML or XLS format. However, neither format is perfect. Only the XML contains the dates properly, and only the XLS contains transactions properly. I did a power query for the XLS, but I would like to get the column for the dates from the XML. Can it be done in one query (without having to create a query for each format and then creating a third query for merging them)?

Thanks

 

[RoryA]

The first two are quite a bit more involved than I was assuming. I would honestly suggest that there is no benefit at all in combining those into one. It will be much easier to maintain them separately, especially if one or both formats change.

 

[deLockloire]

Okay. You have much more experience than me, so I accept. Thank you!

 

[deLockloire]

Actually, it just occurred to me, what if I move most the operations to the merged query (except the expand and index column operations, which need to be done)? Would it then make sense to create one query out of the three?

 

[RoryA]

I don't see much commonality between the two queries, and I still don't really see what benefit you gain?