Hello all.
I have not been able to populate a table via a search that uses inputlookup. My table is only populating with the data from the events. Where did I go wrong?
My search:
sourcetype=integration.wmb.event SAPTransactionID
| append [ |inputlookup idocsDec.csv | fields + CREDAT,CRETIM,hour,minute,STATUS,TID | rename TID as SAPTransactionID]
| transaction SAPTransactionID
| table SAPTransactionID CREDAT CRETIM hour minute STATUS
The only data that gets populated in the table is the SAPTransactionID. All of the other fields that I want to pull data from the csv are empty.
... View more