Using regex for generating generic column names by
Hi everyone, I am trying to make a join on two tables that share not only Key attributes but column names, e.g 1960, 1961..., 2010 (although column values differ in both tables). After doing the join I got a table with duplicate column names, but different data. I want to name one set o these columns as p1960, p1961,...p2010 letting the other as is. I have tried the tool Replace by Generic name and put this regex in the generic name field p\b(19[6-8][0-9]|199[0-9]|200[0-9]|201[0-7])\b but It didn't work. Any help is appreciated.