Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
5 years ago
Solved

File name startwith as parameter

Hello,   i built a few queries with power query and i want to pass the filenames as parameters. often, the files start with the same string and end with dates or numbers.   i managed to have the...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago
    	let
    fx=(p as text)=> let
    Source = Folder.Files(Dossier_Données),
    #"Colonne conditionnelle ajoutée" = Table.AddColumn(Source, "NomFichier", each if 
Text.StartsWith([Name], p) then [Name] 
else null),
    #"Colonnes permutées" = Table.ReorderColumns(#"Colonne conditionnelle ajoutée",{"Content", "Name", "Extension", "NomFichier", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}),
    #"Lignes filtrées" = Table.SelectRows(#"Colonnes permutées", each ([NomFichier] <> null)),
    #"Colonnes supprimées" = Table.RemoveColumns(#"Lignes filtrées",{"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}),
    NomFichier = #"Colonnes supprimées"{0}[NomFichier]
in
    NomFichier
    in 
    fx
GeekAlfPro's avatar
GeekAlfPro
Helper V
5 years ago

Hello smpa01 

it works, thanks.

just a question, i had the "rebuild this data combination" error in all nested queries in my project, is it a normal behaviour of Power Query ?

 

i found a workaround here

smpa01's avatar
smpa01
Community Champion
5 years ago

I am sorry to hear that you are getting that error. Power query does generate that weird error. I also had that error at some point. I also refereed to the same URL as you did. But don't remeber if that solved my trouble.

 

Do you mind creating a seperate thread for that issue in particular with all the detailed code and snapshot of the query step which generates this bug.

 

I will try to solve that but if dor some reason I can't, someone else will for sure.