Forum Discussion

Tmk123's avatar
Tmk123
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper II rankHelper II
3 years ago

That worked!  Thank you so much lbendlin !