Import excel document with Mutiple sheets but the attributes

0
Hi expert, Requirement: I want to import excel sheet with multiple sheets within the file. But the main catch is the attributes withing both the sheets comes from the same entity in mendix. For example: Entity X have attributes A,B,C and D   Sheet 1 has attribute: A,B Sheet 2 has attributes: C,D   So I want to import aall the records from all sheet. What I have done: I have created 2 diff templates. template 1 has colum A and B and template 2 have column C and D I have attached how the data is coming to me in the screenshot. Please help me with the same.
asked
1 answers
0

Hi Harsh, 

 

I assume you have a key (unique identifier) in both sheets, right? Because that's how the importer knows which object you need to synchronize.

 

This said, using the 2 templates is a viable solution, but please note that you need some sort of key or unique identifier in each sheet to properly set the attributes to the correct object.

 

Hope this helps,

João

answered