+ Reply to Thread
Results 1 to 6 of 6

Power Query / Get & Transform filtering on text

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Power Query / Get & Transform filtering on text

    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

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Query / Get & Transform filtering on text

    maybe use IF column then filter by it

  3. #3
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Re: Power Query / Get & Transform filtering on text

    Tried to add a conditional column but then it also did not recognize my text value.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Query / Get & Transform filtering on text

    pictures are useless, attache example excel file

  5. #5
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Re: Power Query / Get & Transform filtering on text

    I found out the reason, very silly, sorry: case sensitive......

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Power Query / Get & Transform filtering on text

    this is a basic rule in PowerQuery not silly reason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query: Reading a text or csv file that is publicly available on the Web?
    By learning new things in forum Excel General
    Replies: 6
    Last Post: 10-31-2018, 03:12 PM
  2. Replies: 3
    Last Post: 04-20-2018, 08:30 AM
  3. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  4. Problem with power query and user added data filtering
    By Pulleritz in forum Excel General
    Replies: 4
    Last Post: 02-19-2018, 03:57 AM
  5. [SOLVED] Power Query - Filtering question
    By orhanceliloglu in forum Excel General
    Replies: 4
    Last Post: 12-05-2017, 04:37 AM
  6. [SOLVED] Change data structure using Formula or Power Query ( Get & Transform)
    By chullan88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2017, 02:58 AM
  7. Get & Transform (Power Query) not showing certain tables
    By BamBamMoneyBags in forum Excel General
    Replies: 0
    Last Post: 03-22-2017, 12:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1