Hello All
My table looks like these
Number Name Position Login1 Login2
1 John expert johns1 johns2
is it possible to make another table which looks like
Number Name Position Login
1 John expert johns1
2 John expert johns2
Thanks for all answers!
If you have just two fields you can do this:
base search | eval Login = Login1."###".Login2 | fields - Login1 Login2 | makemv delim="###" Login | mvexpand Login
try using transpose to your result..
....your search |table....|transpose
If you have just two fields you can do this:
base search | eval Login = Login1."###".Login2 | fields - Login1 Login2 | makemv delim="###" Login | mvexpand Login
You could insert this:
... | fillnull value="n/a" Login1 Login2 | ...
and it does not work for case like this user has only Login1 OR Login2
Number Name Position Login1 Login2
1 John expert johns2
2 Willy expert will1
Huh? How does it work and throw an error message at the same time?
Thanks, it works!
But with message like this
Field 'Login' does not exist in the data.
Maybe something like this?
<your search> | rename Login1 as Login | rename Login2 as Login | sort by Login | table Number,Name,Position,Login
sorry, but not
this way table looks like
Number Name Position Login2