Hi,
I tried to import the attached .TXT report; the measurements are repeated for each parameter: PARAM1, PARAM2, PARAM3.
I removed unuseful rows and cleaned up the data as much as I could. I only need the parameters' names and don't need their Descriptions or Units.
I don't know how to transform the data to obtain a table with a header like: PARAMS, EVNT, POINTS, MEAN, AMP, AVG, OSC, PEAK1, PEAK2, LOW, HIGH, REF.
I unsuccessfully tried to bring the three PARAMs in a column. Any help is greatly appreciated.
Thank you,
Emil
I managed somehow to transform (unpivot) the data the way I wanted. It seems a long and convoluted way. If someone comes up with a better way I'll appreciate it.
Thank you,
Emil
Hi Emil,
Welcome to our forum! It's great to see you're having a go yourself. You can simplify the query by using Split Column by Position. See example file attached - connection only query 'DATA-2'.
Note: you'll need to change the file path back to your own PC's directory.
Mynda
Hi Mynda,
Thank you for your prompt response! Your solution is a lot simpler than my approach. Newbies like me cannot see the forest because of the trees.
I like the Conditional Custom Column idea.
I enjoy your Power Query course !
Thank you!
Emil
You're welcome, Emil. It all comes with practice and you're practicing, so that's the most important thing 🙂
