New to Power Query, and trying to figure out how to get at both the LIST items and RECORD structures of this JSON file at the same time.
I know how to get any one of the record types and output to a table, but can't grasp how to get them together. Doing separate queries seems the wrong approach.
So, how to get at both the LIST and the RECORD data at the same time , in the same query?
Clipboard01.jpg
No one ? Is the question understood ?
Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.
1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired results are also shown (mock up the results manually).
3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).
4. Try to avoid using merged cells as they cause lots of problems.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Well, I thought I was giving enough info to be understood by posting an actual screenshot of the PQ Sources screen , and what it sees a the contents of the JSON file
I figured anyone familiar with PQ and JSON would understand the question without needing actual data.
Basically , asking how to send multiple JSON data types to a table(s) using a single query .
Your question has been understood. Remember you are the one asking for help ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I remembered that if I wait for an answer I'll wait a very long time.
This wasnt a really hard question. Found the answer on my own , as Ive done for the last 35 years
Thanks for asking.
Please share the solution for the benefit of all.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Still polishing it up, but basically you need to use the append or merge feature to combine two distinct queries into one table
Wanted to do it all within one query to avoid going out to the same URL twice to get the same exacta data . Not sure how to do that .
OK - please provide a sample workbook. If you are not prepared to do so, then I think you are seriously limiting the help you'll get here and then, yes, you will be waiting a long time (and sarcastic comments like that don't help, by the way). The ball is in your court.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks