Need help with tables in Power Query

[AlertMtl]

Needing some help combining columns in power query that either contains table data or "Null". These are laser cut files that I need to extract attributes from ex. material, thickness and so on. There seem to be two formats, attached are 2 files opened in notepad, for these files (close to 15K). I will attach a screenshot of where I'm at in Power query. I was able to make a sample file for each format but unsure what to do from here.

 

[C Moore]

Can you run the query for each source separately and then append?

 

[herr_morty]

Sorry, not sure what you need to do with the data. Can you please specify a bit more?

If you need all the data from the #2 "Transform data" columns in one column, I think you could use a new conditional column (e.g., if column 1 is not null, than column 1; if column 1 is null, than column 2; else null)

Let us know

 

[AlertMtl]

I need to get all the data together in the attached format to be able to have it migrated into new software. I am very new to this so forgive my ignorance...I'm not sure exactly sure how the merge and append works. Although the 2 different formats look to be very similar the problem is when you click on table they open differently. Notice the screenshots attached for each format, needed data is in both but different route to get to it

 

[sandy666]

I suggest to post links to these two xml files shared via onedrive, googledrive, dropbox or any similar

 

[AlertMtl]

https://alertmetalworkscom-my.sharepoint.com/:f:/g/personal/robbie_alertmetalworks_com/Ev_1txWIxQdDqzCNPWU77VcBUEB9ohUrZu4BaL99fzuAqA?e=Rt0Rn3

LET ME KNOW IF THIS LINK WORKS....IT SHOULD BE 2 FILES, ONE OF EACH "FORMAT"

 

[sandy666]

check this

s666-PQ-AlertMtl.xlsx

Microsoft Excel Workbook

1drv.ms

 

[sandy666]

I forgot to say you need change path to the files for your own

 

[AlertMtl]

@sandy666 THANK YOU FOR HELPING WITH THIS...I EDITED THE FILE YOU SENT TO SHOW THE FORMAT IM LOOKING FOR. THERES A SCREENSHOT ATTACHED SHOWING THE 29K PLUS FILES THAT IM NEEDING THE DATA FROM...HOW CAN I APPLY THIS QUERY TO THE WHOLE FOLDER? THANKS AGAIN FOR THE TIME

 

[sandy666]

Could STOP SCREAMING? Please?

I will need three files more for testing