Forum Discussion

maracles's avatar
maracles
Icon for Resolver II rankResolver II
8 years ago
Solved

Using a table column as a list of values for a parameter

I am learning to use parameters and I want to use them to make scraping data from IMDb easier.  I want to pull in a couple of fields of data per film (release date, country and director) from IMDb...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi maracles,

     

    => Instead I have an existing table which contains data imported from a workbook. One of the columns on this table is IMDB ID.

     

    To create a parameter and give it values from this column. You can refer to following steps:

     

    1. Go to Edit Queries, choose the IMDB ID column, go to Transform -> Convert to List. Then you'll get an signle list with IMDB ID values. Please be noticed, if you want to keep original table, duplicate a table before doing convert. Also you can remove duplicates inside this column. Please refer to following sample:

     

     Original TableConvert column RecordType to List and remove duplicates

    2. Create a new parameter, set the Suggested Values to Query (the list we generated above), and give a default value.

     

     

    3. Close&Apply. Then you can see all the values in the column are in the drop down box of this parameter.

     

     

    Thanks,
    Xi Jin.