Import data from one list item to other list items in same module(one to Many)

Hi All

I am having a module with a list(A,B,C...) and line items as given below.

Update ,Text, Number are user input fields.

Scenario:

If an user checks update for C list item and updated text , number fields then the updated fields should import to the list item A,D as emp id and Emp Name are same.

	code	EMP ID	EMP Name	Update	Text	Number
A	1	EMP1	Beck		XYZ	120
B	2	EMP2	Siri
C	3	EMP1	Beck	TRUE	XYZ	120
D	4	EMP1	Beck		XYZ	120
E	5	EMP2	Siri

Please help me with this.

Thanks

Accepted answers

All comments

anand.shekhawat

@tejaswini

Yes you can do that, just filter on the basis of the Update(boolean) line item and create a saved view. Now use this saved view for the import. You will get only the checked items updated in the system.

~Anand

tejaswini

@anand.shekhawat

The use case is the data which is associated with C (ie if user update C)should import to only to A & D as they are having same Emp names it shouldn't get imported for remaining list items

In the same way if user is updating B the updated details should go into Only E

	code	EMP ID	EMP Name	Update	Text	Number
A	1	EMP1	Beck		XYZ	120
B	2	EMP2	Siri
C	3	EMP1	Beck	TRUE	XYZ	120
D	4	EMP1	Beck		XYZ	120
E	5	EMP2	Siri

anand.shekhawat

@tejaswini

You cannot do that in this module. You would require a different approach for that.

Create one more module dimensioned by Employee List. Now import the Data (Text and number) with respect to the Employees. Now reference that data here in this particular module using a LOOKUP on Employee ID.

~Anand

abhay.kanik

@tejaswini

I suggest you to use a custom version list with 2 items, let's say original and updated .

Create a boolean and compare it with the original version .

whenever user will updating something in updated version boolean will go true and use that as a filter for your saved view for import.

Crate another action which will import from updated version to current version and add it in the end pf the process.

Thanks

Abhay

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…