Skip to main content
Question

How to get unique code depend from two columns?

  • July 12, 2019
  • 1 reply
  • 5 views

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

 

 

 

1 reply

Forum|alt.badge.img+2

@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:


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