Need help with tables in Power Query

AlertMtl

New Member
Joined
Feb 14, 2020
Messages
5
Office Version
365
Platform
Windows
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.
 

Attachments

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

C Moore

Active Member
Joined
Jan 17, 2014
Messages
466
Office Version
365
Platform
Windows
Can you run the query for each source separately and then append?
 

herr_morty

New Member
Joined
Jul 26, 2020
Messages
6
Office Version
365
Platform
Windows
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

New Member
Joined
Feb 14, 2020
Messages
5
Office Version
365
Platform
Windows
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
 

Attachments

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,778
I suggest to post links to these two xml files shared via onedrive, googledrive, dropbox or any similar
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,778
I forgot to say you need change path to the files for your own
 

AlertMtl

New Member
Joined
Feb 14, 2020
Messages
5
Office Version
365
Platform
Windows
@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
 

Attachments

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,778
Could STOP SCREAMING? Please?

I will need three files more for testing
 

Watch MrExcel Video

Forum statistics

Threads
1,102,351
Messages
5,486,357
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top