Add a Portion of an Array Variable in a Data Grid
When adding an array variable onto a data grid it will give you all of the options in the array. What if you were only interested in a portion of the array variable.
I'll be using this variable Newspapers in this example from our holidays database. For this example I will use this as my selection from the Newspapers array variable of The Times or Daily Express.
If I drop a Data Grid on my selection and left drag the Newspapers array variable on to my Data Grid it looks like this. The Data Grid will show all of the options for the array variable. For instance this person Mr Lee reads the Daily Express which is part of my selection, but I'm only interested if he reads The Time or Daily Express. The other newspapers like the Dail Mail in this case don't interest me and are white noise.
If you only want to add a portion of the array variable onto a Data Grid this is how you do it.
When you drag the array variable on the data grid instead of using the left mouse button like normal, use the right mouse button to click, drag and then drop onto the data grid.
You will then be given these options.
Choose Add selected codes
I will choose The Times and Daily Express as those are the only newspapers I'm interested in and then press build.
Now my Data Grid looks like this with just those two Newspapers I'm interested in from the array variable.
If I had a different selection which was nothing to do with Newspapers, you might get a no no in your Data Grid if the Person only read the Guardian for instance.
Related Articles
How can I schedule the Variable Scanner?
It is possible to schedule the running of the Variable Scanner by using a command line and then using Windows' Task Scheduler in order to schedule the batch file. Firstly, you need to install and configure the Variable Scanner so that it scans your ...User Filter No 'Add Filter' Button
This is a system setting in Orbit to add or remove user filters in Dashboards. You do need Orbit administrator rights to be able to make this change. If this setting is turned on a user will be able to add their own user filters from any of the ...Problem using Post Load Action (Combine Categories) with data from Snowflake
A user reported that they were in the process of rebuilding a system from a new ODS (Organisation Data Source) within Snowflake. The data contained 3 separate ID variables together with descriptions and the user was aiming to merge these as a ...Import a list of dates and URNs and run a selection to find the date in the system with the same URN and previous to the one in the list.
A client asked us for a method of importing a list of URNS and Dates, into an existing FastStats system, and then to suggest a method to compare the imported date to other dates for the same URN in order to then provide the previous date attached to ...Combining Table Results in Orbit using a CubeLookup Expression
Sometimes it is useful to be able to get results from a Table in Orbit and use them in another Table. Within Orbit, it isn't currently possible to refer to results in one tile within another one. However, we can use a combination of some powerful ...