I have the following problem I would like to solve
Numbers1 Numbers 2
I want to concatenate so it will be like this
I have tried field aliases, mvjoin, coalescence, eval with the (.) but still can't seem to figure it out.
So I was able to solve it with the help of a good friend. I used |makeresults command to just test it.
| eval numbers=random()
| eval numbers2=random()
| eval numbers3=random()
| fillnull value="" numbers numbers2 numbers3
| eval test=numbers.".".numbers2.".".numbers3
| eval testing=split(test,".")
I used the random() function to just generate some random numbers
So imagine numbers 1=123
So imagine numbers 2=456
So imagine numbers 3=789
fillnull fills in the values from the fields we are using
we eval to basically combine the fields
then finally we split by the delimiter/separator(in this case ".") we used in our previous eval
I hope I explained this well.