Skip to main content
Solved

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

  • November 16, 2021
  • 3 replies
  • 22 views
I
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"||'%'

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

I
Forum|alt.badge.img
  • ikubra800
  • Author
  • 27 replies
  • November 16, 2021

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

 

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3422 replies
  • 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"||'%'

 

I
Forum|alt.badge.img
  • ikubra800
  • Author
  • 27 replies
  • November 16, 2021

Thanks @ebygomm​ for your answer. It works

 

Community Stats

32,061
Posts
121,725
Replies
39,688
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.