Hi!
I am trying to filter a table in Get & Transform on a text ("contains") but it just won't work...
In Excel is works, int he regular table but in Get & Transform it doesn't. It returns an empty table. I tried two different columns (both on text) and they both react the same.
If I filter on only 1 letter it does seem to work but when I add the full work it doesn't.
I tried to create a dummy table and do the same, that actually worked. But I don't see any strange formatting or anything in the original data. If I use the search box, it does work, but I need to apply multiple filters at once so that won't do. Tried different words as well...
Anyone has any idea how come?
Text filter Contains.JPG
Text filter Contains - empty table.JPG
Bookmarks