-
All-in-one prototyping tool
-
WebHi-fi prototypes for Websites & Web Apps
-
MobileCreate lifelike iOS & Android prototypes
-
Collaborative prototyping
-
CollaborationShare and get feedback
-
RequirementsRequirements management
-
IntegrationsSketch, JIRA and more
Just to add, the above expression does select all matching values to field1 from DM, however they are returned as a single row value separated by commas. This is what I want:
Datamaster 1:
1,A
1,B
2,C
2,D
2,E
3,A
3,F
Datagrid:
H,1
K,3
O/P Required in Result Datagrid (Filter Column 1 of DM1 against Column 2 of Datagrid):
1,A
1,B
3,A
3,F
So what kind of expression can be created for the result datagrid?
Thanks
Hi Arnab,
You can do the following:
1. Create two datamasters, in your case Datamaster1 and Datagrid. Add a data grid into the canvas. Select the Datamaster1 and click ok.
2. Create an "on page load" event and select set value.
3. Now, click on the datagrid and calculate the following expression:
In my case, "test" is your datamaster1 and "test2" is your small datagrid (H,1; K,3). "number2" is from "test2" and "number" is from "test"
I hope it helps you
Thanks a lot Albert. It worked.
Comments have been locked on this page!