Question

How to get unique code depend from two columns?

  • 12 July 2019
  • 1 reply
  • 1 view
Z
Badge

 

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

M
Badge +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:

Reply


Community Stats

28,716
Posts
109,494
Replies
36,561
Members
Terms & ConditionsCookie settings
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.