topic Re: Creating a filter that filters a row multiple times in App Development

Creating a filter that filters a row multiple times

abdullah_unal — Tue, 06 Nov 2018 13:20:05 GMT

Hi, I have some campaign names such as A, B, C, A&B, and A&C. A&B and A&C mean that that row assigned to 2 campaigns. I want to create a filter that shows only A, B and C campaigns. For example, when B is selected then B and A&B campaigns must be filtered, when A is selected then A, A&B, and A&C campaigns must be filtered. Is there any way to create a filter like this?

Re: Creating a filter that filters a row multiple times

dplr-rn — Tue, 06 Nov 2018 18:32:38 GMT

You will need to create a table which maps the combinations with values

Campaign Name Campaigns

A A

A A&B

A A&C

Doing it programmatically should be possible with nested for loops

Re: Creating a filter that filters a row multiple times

jheasley — Tue, 06 Nov 2018 18:47:01 GMT

You could create a small additional table using SubField(). If the Delimiter is always '&', then it should be SubField(Campaigns,'&'). This SHOULD give you all possible campaigns as independent values if you load it separately. something like

Load

RecordID,

SubField(Campaigns,'&') as Campaign

Resident ORIGINALTABLE;

Re: Creating a filter that filters a row multiple times

abdullah_unal — Fri, 09 Nov 2018 09:26:36 GMT

Thanks for your reply, It has worked.

Re: Creating a filter that filters a row multiple times

abdullah_unal — Fri, 09 Nov 2018 09:27:45 GMT

Thanks for your reply Joe, but we need to map original campaigns with new columns that we create in a new table.

Re: Creating a filter that filters a row multiple times

jheasley — Fri, 09 Nov 2018 18:05:04 GMT

understood. i like dilipranjith‌'s answer as well. my approach is designed to be a self-updating approach. you could make it into a mapping table if needed. either way, i am very glad your problem was solved!