Skip to main content
November 11, 2024
Question

I have a requirement to make logic when suppose I have a table with different columns as:

  • November 11, 2024
  • 4 replies
  • 0 views

Hi ,

I have a requirement to make logic when suppose I have a table with different columns as:

A, B, C, D and here there are 5 version for each row example:

V1 has A1,B1,C1,D1

V2has A2,B2,C2,D2 and so on till V5

Now what is need to be done is when user is updating v1 version then he is allowed to update only D1  and once he update D1 column as 2 then future version of

D2, D3, D4, D5 will only update as 2 when A1+B1+C1 combination contains exact value and if any of the version does not contains the combination of A+B+C then value of D as 2 will not update for that version

example:

V1:  A1=cat  B1=dog C1=bat D1=1

V2: A2=cat B2=dog C2=bat D2 = 2

while updating D1 = 5 ( V1: A1=cat B1=dog C1=bat D1=5)

then value changes for V2 (future version only if a1 b1 and c1 is identical as a2 b2 c2):

V2: A2=cat B2=dog C2=bat D2= 5

[mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  

4 replies

kumara0180
November 11, 2024

Can you post the data of table in tabular format in before and after format. 

stefanhelzle0001
November 12, 2024

I have the feeling that I missed your question. What exactly are you looking for?

November 12, 2024

I just want to built logic on script task

here V table is different and there another table as xyz where A B C D is stored but A B D is directly link with xyz table and C is coming from abc table

stefanhelzle0001
November 12, 2024

OK. Now, what are you stuck with? Do you have anything you can share?

To be honest, I tried to understand that logic, but failed.