Looks like I hit a block with something I reckon must be quite simple.I have a ranking table 1: (file 1)Ranking  ID1    A  2    B  5    C  6    D  12   nfile 2: A    A    A    B    B    B    C    C    n   I need to apply the ranking to another table where IDs are not unique and expect to get this(desired output):A   1  A   1  A   1  B   2  B   2  B   2  C   5  C   5  n   12 Can you point me towards a friendly manual ? ;) I would prefer to solve it in command line but Python and Libre office solution can do as well.
Table transformation
text processing;scripting;python;columns;libreoffice