How to insert dummy data into the first few entries of a field?

[splunker-0625]

Here is the original table here, but I need to put some dummy data into Field_B 

Time	Filed_A	Field_B
1	10	Tom
2	20	Smith
3	30	Will
4	40	Sam

Like this,

Time	Filed_A	Field_B
1	10	DUMMY1
2	20	DUMMY2
3	30	Tom
4	40	Smith

I want to expect the order of Filed_B will be : DUMMY1,DUMMY2,Tom,Smith,Will,Sam...
Please advise me on how to write the eval command to do this...

[liuce1 · Accepted solution]

The SPL as below, I store your previous table in a lookup table test.csv

| inputlookup test.csv
| sort Filed_A
| autoregress Field_B as newfield p=2
| fields Time Filed_A newfield
| streamstats count as num
| foreach newfield [| eval <>=if(isnull(newfield),"DUMMY".num,<>)]
| rename newfield as Field_B
| fields Time Filed_A Field_B

If my answer can help you ,please kindly vote it . 

Thank you

[splunker-0625]

Hi liuce1,
Thank you for your reply
Your idea that is using autoregress, seems working for me. 

I could make put some dummy data for my targeting column with a simple procedure.

Thanks,

[richgalloway]

If Field_B is a multi-value field then you could use mvappend to add the values.

| eval Field_B = mvappend("DUMMY1", "DUMMY2", Field_B)

If Field_B is not multi-valued then please share the query that produced the results so we can tell you how to accomplish your goal.