•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query: my source doesn't always contain the same columns. How do you handle this?
Our take
Navigating inconsistent data from your CRM can be challenging, especially when essential fields appear and disappear with each report. Power Query offers a solution to streamline your workflow, allowing you to manage these variable columns efficiently. By leveraging its adaptive features, you can set up dynamic queries that automatically adjust to the data available, saving you time and reducing manual corrections. Dive deeper to discover practical strategies for maintaining robust reporting without the hassle of constant adjustments every refresh.
Hi all.
I'm producing reporting based on data from our CRM. They're using Looker. My issue is, Looker seems to only generate a field if there's data for it. So my data can include a field on one period, but it might not be present on the next - let's say if no items for Smartphones category are sold, the csv won't have a smartphones column.
What's the best way to handle this so that I don't have to spend time every refresh to fix the queries?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- PowerQuery and add manual dataHi everyone, I have a Power Query in Excel that outputs a table with [title] [date]. I need to manually add the Sprint number in an extra column [sprint] to specific combinations, aka "I will work on this this month." The problem is every time the query refreshes, any manually entered data gets lost or misaligned. - New rows come with the needed values. - Row order changes. Because this table is used by many people, I want them only to add the sprint number, nothing else, no copying data or anything. I would like to know more about your experiences when data needs to be written infrequently but many times. I am open to know more for powerbi options direct dashboard too. submitted by /u/No_Solid2349 [link] [comments]
- Power Queries as inputs changeI have a main spreadsheet that is fed by some instrument logs among other things. These inputs change from time to time due to instrument software updates. I can update the power Queries but then it breaks the old files. How do people handle this? submitted by /u/Javaslinger [link] [comments]
- Power query and manual table next to itHi, I want to pull data verbatim from a spreadsheet my team uses and use data from it for my own purposes. The main goal for using power query is that the data updates on my spreadsheet. Mainly, if any new entries are added at the bottom. I also have some manual fields that I need to add that correspond with the power query data. I've added another table beside the power query data, and filtering it causes the data on both sides to adjust correctly. I'm mainly concerned that, if the entries are rearranged or sorted on the original sheet, that my tables will not align after a refresh. Also, if a refresh would break my table alignments at any point. Is my fear founded? Is there a way to combine the two features that I need into a single table? submitted by /u/Perspective-Guilty [link] [comments]
- Power query for a large datasetMy company uses a horrible format for its daily production sheets, but the data can be pulled through power query. I want to build a reporting tool for looking at any major trends that are currently missed. Ideally looking at part efficiency by machine type and some other descriptive data too like efficiency by shift manger etc. My problem is that even after cutting unnecessary columns and filtering unnecessary rows, it takes forever to load anything. ChatGPT isn’t all that helpful, I’d like some expert advice please! For info, rough number of rows of data is about 50,000 per year. I want to cover at least the last three years. Sheets are all saved into a folder by month, within a folder by year. submitted by /u/CanJesusSwimOnLand [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#big data management in spreadsheets#conversational data analysis#intelligent data visualization#natural language processing for spreadsheets#rows.com#Excel compatibility#cloud-based spreadsheet applications#Power Query#source#Looker#reporting#CRM#data#Smartphones#field#csv#columns