Forum Discussion
Multiple choice with data import parameter
Hi,
i create the parameter "idcompany" to filter data before import by the company ID.
I have company A, B and C.
I apply the parametr to a table column to filter data befor importing:
Through the parameter I can filter by single company before importing the data.
The problem is that whe i manage the parameter to limit the data to import i am able to filter from a drop list only one company at time for example import data of only company A or import data of only company B.
Is there a way to create a parameter that allows to choice if import data from only one company or from all company? A sort of multi check drop list
Thanks
4 Replies
Two ideas to try
1. Make multiple parameters and use some "or" logic in your Company filter step prior to getting the data
2. Enter the companies as a text string separated by a delimiter in a single parameter, then use Text.Split() to create a list from that. You can then use List.Contains(parameterlist, ... to keep only the companies in the list.
Regards,
Pat
Thanks for the tips, i have 100 company to pass in the parameter so solution 1 is hard to implement and use; on a list of few companys it work well.
I don't understand well solution 2, can you please give me an example?
at the and i need to save the model as a template, so that end user will able to select from the drop list which company's data load (data of only one company or data of all company)
Thank
In #2, your users would enter a list of companies into the text parameter, not choose from a list.
Company A, Company C, Company F for example.
However, this article by Chris Webb shows that doing a multi-select parameter is possible with the new Dynamic M parameters feature (I haven't used it yet, but it looks straight forward).
Regards,
Pat
