Filter Table.SelectRows from cell rang in sheet

[Shayanan]

I Imported some data from folder. folder has 100 txt file. I need select txt file based on names listed in column2 at sheet2.

Originally they are selected manually in power query and code is like that:

let

    Source = Folder.Files(Table.FirstValue(Excel.CurrentWorkbook(){[Name="FolderPath"]}[Content])),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "TSLA.txt" or [Name] = "AAL.txt" or [Name] = "AAPL.txt" or [Name] = "ACST.txt" or [Name] = "ADTX.txt")),

but I want read value of cell in column2 sheet 2 (included TSLA,AAL,AAPL,ACST,ADTX), so if I changed value from TSLA to AZN, filter changed automatically and replace AZN.txt .

 

[arunsjain]

Hi

File selection/Filter is hard coded like "TSLA.txt". There is other way around. You can add some common text in name of each file like TSLA PQR.txt , AAL PQR.txt.

Then apply filter like below. You can change file name but keep that common text (PQR) with the new name of that file. You can choose any common text. I choose PQR as an example. I hope it will help.

#"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Name], "PQR")),