Filtering Import

Sravan_Kumar

This is my Original Module.

Now I want to create a New Module which will have only Orange Data.

But I can't use Lookup, as I have restrictions of Formula Linking.

Only thing I can do is Import.

Is there any way to do it?

Need your support.

Accepted answers

cmaurice

A - Create :

A system module to define the filter criteria
A boolean line item to filter your data in the source module (formula should be like Item(Fruits) = System Module.selection)

B - Create a saved view using this line item

C - Create your import using this saved view (my advice is to update a subset of the existing list to be used in the new module)

Hope it helps !

Akhtar.shahbaz

Hi @Sravan_Kumar

No need to create a new module, just create a view and filter out the fruit type Orange.

1. Create a system module to select fruit type, here in your case "Orange"

2. create one line item for filter

3. apply the filter you will get the desire result.

Hope this help!

Thanks

Akhtar

All comments

cmaurice

A - Create :

A system module to define the filter criteria
A boolean line item to filter your data in the source module (formula should be like Item(Fruits) = System Module.selection)

B - Create a saved view using this line item

C - Create your import using this saved view (my advice is to update a subset of the existing list to be used in the new module)

Hope it helps !

Akhtar.shahbaz

Hi @Sravan_Kumar

No need to create a new module, just create a view and filter out the fruit type Orange.

1. Create a system module to select fruit type, here in your case "Orange"

2. create one line item for filter

3. apply the filter you will get the desire result.

Hope this help!

Thanks

Akhtar

Sravan_Kumar

Yes absolutely.

Thanks @cmaurice .

Sravan_Kumar

Thanks @Akhtar.shahbaz.

Thanks for the screenshot.

Didn't expect it to be that easy.

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…