Forum Discussion

Copper Contributor

Apr 30, 2022

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...

Diamond Contributor

Apr 30, 2022

Cmpunk

On your samples fie I can't reproduce that, please see attached the file with PQ. Perhaps you may share your one?

PQ from folder.xlsx16 KB

Cmpunk
Copper Contributor
Apr 30, 2022
SergeiBaklan Thank you for your response.

Please find my attached file:

PQ .xlsx18 KB
- SergeiBaklan
  Diamond Contributor
  Apr 30, 2022
  Cmpunk
  
  That is Change Type in sample file since it uses exact column names. First Unpivot, next set types.