Jump to content
We've recently updated our Privacy Statement, available here ×

How to change a composite key?


viniciusrabelo

Recommended Posts

Hi,

I have three tables: A, B and AB and the key of table AB is a composite key of table A and table B.
How can I change an composite key between two tables?

I tried with tMap, but I need to link the key that I want to change, then I can't indicate what key will be the new value...

Thanks a lot

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

  • 4 weeks later...

I believe tMap should suit your needs. You'll just need to (manually) change the value of required fields in output table. This can be achieved by adding simple expressions.

You may want to check the JasperETL Guide from the "Docs" section for tMap examples.

 

HTH

Stas P

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...