Skip to main content
Solved

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


Forum|alt.badge.img

table 1

table 1table 2table 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

......

......

 

Best answer by ebygomm

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"||'%'

 

View original
Did this help you find an answer to your question?

3 replies

Forum|alt.badge.img
  • Author
  • November 16, 2021

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

 


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • Best Answer
  • November 16, 2021

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"||'%'

 


Forum|alt.badge.img
  • Author
  • November 16, 2021

Thanks @ebygomm​ for your answer. It works

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings