•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?
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]
Want to read more?
Check out the full article on the original site
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