Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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;
Thanks for your reply, It has worked.
Thanks for your reply Joe, but we need to map original campaigns with new columns that we create in a new table.
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!