Linking subsets to a new list

If i have created 5 subsets from a long list and a new list (Subset 1 to 5). Is there a way i can set the formula in my properties of my longlist to command that all items included in the subset 1 shall be tagged as part of the new list for Subset 1 instead of doing it manually? Thanks in advance! Appreciate your help! 🙂

Accepted answers

DavidSmith

@elaine.novel

Ok, I think I understand what you are trying to do and it is a little involved and would require some maintenance if you create a new subset (and subsequent choice), but otherwise it is automatic if you change the members of the existing subsets

1. Subsets on the long list

2. Create a list "mirroring" the subsets

3. Create a module with a line item for each subset (dimensioned by the subset), and enter TRUE as the formula

4. Create a module dimensioned by the list in 1, and add a line item for each subset. pint the line items to the respective formula from 3.

5. Create a module dimensioned by 2., with line items for each subset and manually check the respective element

6. Now we know which list items from 1 are in which subset and we know which list item from 2. corresponds to each subset , so lets bring it together in 1 module dimensioned by 1 and 2 with line items for each subset member and a check

7. I've assumed you have a module something like this, where the subset "choice" is made

8. You can now bring in the value for those list items that are in the chosen subset

9. This will then work if you change the elements in the subset

So the maintenance for adding a new subset would be:

a. Add a new element to the list in 2.

b. Add new line items in the modules from 3, 4, 5 and 6

c. Amend the check formula from 6.

Hopefully this resolves it for you

David

All comments

usman.zia

Hi @elaine.novel

I don't think you can do this by formula (unless proven otherwise).

But this can be updated via an import process.

If you create saved views of all the subsets with a boolean line item which you can use a formula of TRUE via boolean format. Then you can create an action to import these views into the new subset list property. This will update subset items.

I hope this helps and if you have any questions please do let me know.

Thanks

Usman

elaine.novel

Hi @usman.zia

Appreciate your response. The import cannot be an option. I will need to tag the subset to the new list because the dropdown will be the new list. I tried to create a property though in the long list but I was thinking if there is a better way to do it. 🙂

LipChean_Soh

Hi Elaine,

I'm still confused with your requirements.

What do you mean by tagging? Can you create an example of what list 1 and list 2 are? What are the name of the subsets, and what business problems you're trying to solve?

Thanks,

LipChean

elaine.novel

Hi @LipChean_Soh

The requirement is this: i will have to create random subsets in let's say "the long list". Let's say 5 subsets.

Then i will have to create a new list, which will serve as the dropdown in my adjustment module. The new list will contain SS1, SS2, SS3, SS4 and SS5. I need to create a new list because in my adjustment, i will need to select from the new list.

However, the new list should to connected to the 5 random subsets that i first selected from the "long list". Just so when i select SS1, my adjustments will allocate to the first subset, if SS2, to the 2nd subset and so on.

Appreciate your assistance.

Thanks again,

Elaine

DavidSmith

@elaine.novel

1. Subsets on the long list

2. Create a list "mirroring" the subsets

3. Create a module with a line item for each subset (dimensioned by the subset), and enter TRUE as the formula

4. Create a module dimensioned by the list in 1, and add a line item for each subset. pint the line items to the respective formula from 3.

5. Create a module dimensioned by 2., with line items for each subset and manually check the respective element

7. I've assumed you have a module something like this, where the subset "choice" is made

8. You can now bring in the value for those list items that are in the chosen subset

9. This will then work if you change the elements in the subset

So the maintenance for adding a new subset would be:

a. Add a new element to the list in 2.

b. Add new line items in the modules from 3, 4, 5 and 6

c. Amend the check formula from 6.

Hopefully this resolves it for you

David

elaine.novel

Thanks David, appreciate this! 🙂

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…