Output

[Tid14]

Hi, I am creating a workflow in which my Output is coming out to be as mentioned below.

whereas i want output in my B column to be like

 
just referring to “B” column how this can be done? That the values 619 repeats 4 times then 832 and so on.

[ShankerV]

Hi @Tid14 

Wanted to get one clarification, what is the logic how you derive 619 4 times and then 832 4 times.

I can replicate it, but wanted to understand how you want to apply in huge dataset.

Please explain the logic.

Many thanks

Shanker V

[Tid14]

It is a static field while we post entries into the journal.

[ShankerV]

Hi @Tid14 

Here is what you are looking for right, please let me know if otherwise.

Many thanks

Shanker V

[AaronSmatta]

What you can do is use the "select records" tool and split the first 4 records and then use another "select records" tool for the remaining 4 records then use a formula tool to add the specific number to column B for each. Afterwards you can union the records back together, but this is a very manual process.

[ShankerV]

@Tid14 

Did your issue got resolved?? Derived your expected solution??

Many thanks

Shanker V