This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been working on a dataset which has two sets of ids. I am trying to normalize their relationship. It would be super complex to explain the whole logic, however, I'll explain where exactly I am facing problem.
There are two sets of macro which I am running - outer and the inner. The inner macro consist of the main logic, the outer macro consist of - 1) checking the exit condition 2) if the exit condition is not met, it changes the data slightly and re-inputs the altered data until the exit condition is met.
Now, for 1st iteration both the macro works fine. However, when I plug in the actual data, the macro runs into infinite loop.
The ultimate output which I desire is:
Please refer to the attached files. I've followed the intuitive naming for ease.
Thanking you all in advance. Please let me know in case you need clarifications on any thing (I know I've stated things in an air level view)