I have two field names from different sourcetype with the desired value that I want to put in a table with the same name how do i assign the same name to both fields?
For different sourcetypes you can use eval name = coalesce(field1, field2)and combining different field names to single field you use the above mentioned by Takajian eval name = mvappend(field1, field2, ...)it can combine multiple fields to single.
eval name = coalesce(field1, field2)
eval name = mvappend(field1, field2, ...)
eval command is useful to combine filed. Can you try following command and confirm if this work for your case?
... | eval same_name=mvappend(field1, field2)