Really enjoying EasyMorph but did find what appears to be a bug when importing from Excel.
Namely, the same value appears to be coded as two separate values.
I have tried the “Clean” step to remove all non-text values.
Must be something to do with Excel because when I manually convert Excel to CSV the issue goes away.
Have attached my project file and the simplified Excel workbook (and a screen cap showing the issue).
Thanks for this solution!
Yes that was indeed the issue. Problem solved.
I suppose I got tripped up because other tools (e.g. Qlik, Power BI) will automatically trim those trailing spaces. Something to think about.
But since you have pointed out that “Filter/Profile” feature with the Suggestions, it was very easy for me to correct this and I will keep an eye
Overall though I am finding this tool to have many advantages over Qlik and Power Query (e.g. the “Enumerate Rows” action perfectly solved my problem - doing the same in Qlik and Power Query is a big pain).
Thanks again Dmitry!
Agree that transparency is generally a good rule to follow.
I have since taken a second look at the “Sanitize” action and can see it’s actually quite simple to sanitize “All Columns” in a single step.
Going ahead I may make this a habit.