Forum Discussion
Data Transformation Challenge
Hi Anonymous ,
I remembered seeing this, and found it in M is for (Data) Monkey, a very useful book. KenPuls is one of the authors.
So add a custom column with the formula below in the picture in PQ. You get the result in the picture. You can then go to filter for that custom column and unfilter null. That takes away the rows that have bad data. You may want to copy those rows first, so that you could change your original data - you could sort by ascending, and the nulls float to the top.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
I tried that before posting. I was hoping to use the remove error rows functionality. Changing the data type of the column only changes the presentation of the data. It doesn't error. Does anyone know how to force an error instead of converting underlying data to the chosen data type?
Hi Anonymous ,
I remembered seeing this, and found it in M is for (Data) Monkey, a very useful book. KenPuls is one of the authors.
So add a custom column with the formula below in the picture in PQ. You get the result in the picture. You can then go to filter for that custom column and unfilter null. That takes away the rows that have bad data. You may want to copy those rows first, so that you could change your original data - you could sort by ascending, and the nulls float to the top.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielThank you so much Nathaniel_C ! Exactly what I was looking for.