Solved

How to merge these columns like foreign key for table ? (with python code or any transformer tool)

table 1

table 1 table 2 table 2 Expected result is :

table 3:

actgeneric_id------- fNotam_id

1.2.1.1.3.1 ---------- 1.2.1.1.3

1.2.1.1.3.5.1----------1.2.1.1.3

1.2.1.1.3.5.2----------1.2.1.1.3

....

.....

1.2.1.1.4.1------------1.2.1.1.4

1.2.1.1.4.2------------1.2.1.1.4

......

icon

Best answer by ebygomm 16 November 2021, 14:17

Actually, these are xml_id hieararcy for creating the relational database tables.

Userlevel 1

+21

You could use an InlineQuerier to do this,

e.g.

SELECT aa."actgeneric_id", bb."notam_id"
FROM Table1 aa, Table2 bb
where aa."actgeneric_id" like bb."notam_id"||'%'

Thanks @ebygomm for your answer. It works

Sign up