Forum Discussion
Cmpunk
Apr 30, 2022Copper Contributor
Power Query Help!!!
Hello All, I am working on some files which I plan to combine and transform. Since there are multiple files I am transforming the transform sample file so that it gives me desired results. Unfort...
Cmpunk
Apr 30, 2022Copper Contributor
Riny_van_Eekelen I am new in Power Query and don't have much knowledge about M-code. I have attached my M-code below.
Thank you for your help. But I am still getting errors.
If you look at PQ Doubt 4 image I am getting an error line in the columns.
Riny_van_Eekelen
Apr 30, 2022Platinum Contributor
Cmpunk In the file I used I had to remove 8 rows att the top. And then I would remover the Change type step and do that in the "expanded" table. Didn't look at the other files if they had the same number of undesired rows at the top.