Skip to main content
Question

How to get unique code depend from two columns?

  • July 12, 2019
  • 1 reply
  • 8 views
Z
Forum|alt.badge.img

 

Hi together

The initial situation is as follow:

The relation between column TR and column LTG is 1:n.

Every value in the column LTG need to get a unique code independent from TR.

The CODE also has to be unique per TR.

TR

LTG

CODE

A

1

?

A

2

?

B

3

?

B

1

?

C

1

?

C

3

?

 

I would like to get follow result (the code has to be unique per LTG and order is not importent):

TR

LTG

CODE

A

1

2

A

2

1

B

3

1

B

1

2

C

1

2

C

3

1

 

 

 

    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.

    1 reply

    M
    Forum|alt.badge.img+2
    • markatsafe
    • 1891 replies
    • July 15, 2019

    @zoran68 I think you can use the Counter with a Counter Name of "TR". This gives you a separate count Domain for each value of TR, independent of LTG.

    This would b the result:

    Community Stats

    32,080
    Posts
    121,818
    Replies
    39,714
    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.