Forum Discussion
Solved
PowerQuery to understand non-blank columns per category
I'm extracting and appending a significant number of json files which do result in a table with approx 5Mio rows & 127 columns. The structure looks like this: Date Activity Attribute 1 Attribu...
I realized this just involved a normal UnPivot operation followed by a GroupBy. I think I was just intimidated by huge number of rows/columns. Problem solved 😀
I realized this just involved a normal UnPivot operation followed by a GroupBy. I think I was just intimidated by huge number of rows/columns. Problem solved 😀