Forum Discussion

Tmk123's avatar
Tmk123
Helper II
3 years ago
Solved

Source (Excel) has dynamic sheet name

Hi All,    My source is an Excel file.  There is only one sheet found within the Excel file and it is dynamic.     File 1 has a sheet name of:  TRM215-1106217 File 2 has a sheet name of:  TRM215...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Replace the name reference

     

    #"TRM215-1" = Source{[Name="TRM215-1106217"]}[Data],

     

    with an index reference

     

    #"TRM215-1" = Source{0}[Data],

lbendlin's avatar
lbendlin
Super User
3 years ago

Replace the name reference

 

#"TRM215-1" = Source{[Name="TRM215-1106217"]}[Data],

 

with an index reference

 

#"TRM215-1" = Source{0}[Data],

  • Tmk123's avatar
    Tmk123
    Helper II
    3 years ago

    That worked!  Thank you so much lbendlin !