Want to generate same data from one row to the preceding rows

[Komal_]

Hi Team,

I have dataset as below, all am trying to do is get to the row which is "Code" in Data Set column and all the rows in value column before the "Code" row i.e. "Non Code" should be re written by the same value of "Code".

Note: There is huge data set similar to the below and there is no constant count of 

Data Set	Value
Non Code
Non Code
Non Code
Code	-1
Non Code
Non Code
Code	0
Non Code
Code	1
Non Code
Non Code
Non Code
Non Code
Code	2

Expected output

Data Set	Value
Non Code	-1
Non Code	-1
Non Code	-1
Code	-1
Non Code	0
Non Code	0
Code	0
Non Code	1
Code	1
Non Code	2
Non Code	2
Non Code	2
Non Code	2
Code	2

[binuacs]

@Komal_ One way of doing this

[cjaneczko]

One way is to add a record ID and sort tool to the dataset and then reverse sort it. Its easier to use the multirow tool down than it is backwards. See workflow below.

[Komal_]

Hi @binuacs,

Thanks for the quick help, but I have updated my data set to near to my real time data. Could you please try to help me with this.

thanks again!

[Komal_]

Hi @cjaneczko ,

Thanks for the quick help, but I have updated my data set to near to my real time data. Could you please try to help me with this.

thanks again!

[binuacs]

@Komal_ updated the workflow