Forum Discussion

joekoshar's avatar
joekoshar
Regular Visitor
7 years ago
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 wi...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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:

    M Operators

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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:

M Operators

 

Regards,

Xiaoxin Sheng