So basically merging the main sheet and the third sheet is the same way you merge the main sheet and the second sheet i.e. by matching _index variable and the _parent_index variable like you did to merge main sheet and the second sheet.
Merge the main sheet with the first sheet. You should get a new sheet.
Step 2:
Merge this new sheet with the second sheet. You should again get a new sheet. So this new sheet now should have all the variables from main sheet, first sheet and the second sheet.
Thank You for all but i still have some questions.
when i merged the first and the second , i used the Index and Index-Parent.
For merging the new sheet with the third one , which variable key , i am going to use in order to use the coherence
Use the _index from the main sheet and the _parent_index from other sheets. So when you merge the main sheet with the first sheet, you will see the _index sheet in the newly merged sheet. Use the _index again from the newly merged sheet and the _parent_index from second sheets while merging.
Hello Kal Lam
thank you for all support but i have done these steps in vain.
No coherence has been found when i merged the new sheet merged with the third sheet
I still wait for your new support
@Saleontrillioner, maybe you will need first to play around merging the main sheet with the first sheet as outlined in the support article. Once you are good at this, you could proceed to the next step.
Hi @Kal_Lam
Many thanks for that article.
Unfortunately, the files (this one and this one) proposed for practice are unavailable. It tells me that it couldn’t find the page.
Best regards