Doing joins in Loops

4 posts / 0 new
Last post
padmathiagarajan
Offline
Joined: 07/02/2016 - 06:26
Doing joins in Loops

Hi Brian,
I have a file with user rights assigned to roles.
I have another file which has the conflicting user rights. this file has 2 columns T code and conflicting T code. i.e. If T code is F41 and conflicting T code is F56 it means that roles which have F41 assigned and also have F56 assigned are conflicting.
There are more than 100 items for which such conflicts have to be found and around 2500 combinations. 
I manually did this using multiple joins but i was wondering if you could help me with a script which will help to do joins in loops based on key values. If there is any other simpler method also let me know.
I am also enclosing sample file with sample data for reference. 
Thanks in advance for the help.
Regards
Padma

padmathiagarajan
Offline
Joined: 07/02/2016 - 06:26

Hi Brian.. Request you to please help me on this..

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Sorry Padma, I was going to ask you what version of IDEA are you using as this might be solved easier using Python then using IDEA.

padmathiagarajan
Offline
Joined: 07/02/2016 - 06:26

Latest version..Version 11.2. 
Yes sure even Python works for me..I have pycharm and jupyter note book or if its python code to be executed in IDEA also it is fine. Do let me know.
Thanks in advance for the help.
Regards
Padma