Forum Discussion
Data cleansing
- 3 years ago
Hi,
This was the top result when i Google:
https://learn.microsoft.com/en-us/training/modules/automate-data-cleaning-power-query/
I have not used it by my self, but it looks What youre after 🙂
Br
Marius
Hi,
PQ have a lot of data cleansing functionalities, but its hard to do ut automaticly if the issues are diffrent from month to month. If the cleansing you are doing in excel is the same all the time it should be possible to implement this in PQ so it does it automaticly. But if its diffrent every time its harder. All depends on the data and What is the problem time to time.
Br
Marius
Hi mariussve1,
Thank you , we are doing the same type of DATA cleansing in excel on a daliy basis. Based on you advise i understand we can make it happen automatically by using PQ. kindly request to share any tutorial link for the same , thanks in advance
regards,
dsmitha
- mariussve13 years agoSolution Sage
Hi,
This was the top result when i Google:
https://learn.microsoft.com/en-us/training/modules/automate-data-cleaning-power-query/
I have not used it by my self, but it looks What youre after 🙂
Br
Marius