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 filenames, but i'm stuck when i want to transform it in parameters.

For example the following steps : 

 

let
    Source = Folder.Files(Dossier_Données),
    #"Colonne conditionnelle ajoutée" = Table.AddColumn(Source, "NomFichier", each if 
Text.StartsWith([Name], "L083_-_Liste_absences_toutes_categories_par_salarié_sur_une_période") 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

 

is there a way to achieve this ?

 

thanks

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

3 Replies

  • smpa01's avatar
    smpa01
    Community Champion
    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
      • 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.