Filtering Import

Highlighted
Super Contributor

Filtering Import

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.

 

Sravan_Kumar_0-1585841680420.png

Sravan_Kumar_1-1585841823050.png

 

 

4 REPLIES 4
Highlighted
Certified Master Anaplanner

Re: Filtering Import

A - Create :

  1. A system module to define the filter criteria
  2. 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 !

Highlighted
Super Contributor

Re: Filtering Import

Yes absolutely.

Thanks @cmaurice .

Highlighted
Super Contributor

Re: Filtering Import

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"

Screenshot_191.png

2. create one line item for filter

Screenshot_192.png

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

 

Screenshot_194.png

 

Screenshot_193.png

Hope this help!

 

Thanks

Akhtar

Highlighted
Super Contributor

Re: Filtering Import

Thanks @Akhtar.shahbaz.

Thanks for the screenshot.

Didn't expect it to be that easy.