Skip to Content
0
Jun 03, 2018 at 05:31 AM

Data providers changing name or adjusting output data providers

48 Views

Case Data Providers

I have a workbook with several worksheets consisting of queries on more worksheets. When I want to execute the query, I want one worksheet to process data for period 5 Year to Date. For another worksheet in the same workbook (with a different setup of columns), I want to process data for period 4 YtD. When I create a query the data provider gets a name, e.g._Data Provider_1.

Question 1: It is possible to change a name of the Data provider and is so when and where in the process?? I already tried this, by selecting “Eigenschappen”

Question 2: If above option is not possible, how can I change the output (removing unwanted columns) of data providers?

I made Data providers for several worksheets and assigned it to the worksheets. But when using data providers it always return to the setup of the query and I couldn’t find an option to change the settings of the columns which turn out in the query. E.g I always see then actual this year (werkelijk 2018), actual last year (werkelijk 2017) and delta (verschil).

When I change the filter by only selecting Actual this year (Werkelijk 2018), it still gives the output with actual this year (werkelijk 2018), actual last year (werkelijk 2017) and delta (verschil). How can i remove actual last year and delta column?

Please help ��

Kind regards!