Forum Discussion
Solved
Set parameter equal to a specific value in a table
I have a data source in Excel where the title of the file changes daily. I have a separate table (Table1) that has the name of the new name of the file. How can i set a parameter to a single value within a table?
Say for example the parameter must be set to the 2nd column, 4th row of Table1
Hi joekoshar,
Actually, you can use '[]' and '{}' with query table to find out specific cell value.
For example: 2nd column, 4th row of Table1
Custom = Table[Column2]{3}Reference link:
Regards,
Xiaoxin Sheng
2 Replies
Hi joekoshar,
Actually, you can use '[]' and '{}' with query table to find out specific cell value.
For example: 2nd column, 4th row of Table1
Custom = Table[Column2]{3}Reference link:
Regards,
Xiaoxin Sheng
