About fereze

fereze · ‎06-30-2022

Hi I have a table similar to this: Brand ID_EMP Nike 123 Adidas 456 Lotto 123 other table like this: code name 123 Smith 456 Myers The result should be Nike 123 Smith Adidas 456 Myers Lotto 123 Smith but insted of this I'm getting: Nike 123 Smith john adidas 456 Myers. Mike This is the query that I'm using. | dbxquery query="SELECT * FROM Clients ;" connection="Clients" | where NOT like(SAFE_NAME,"S0%") |rename ID_EMP as code | join type=left [| inputlookup append=t Emp.csv | table code, name, STATUS ]| fillnull value="Blank" STATUS | dedup code | where STATUS!="Blank"

fereze · ‎06-23-2022

It works! Thanks!

fereze · ‎06-23-2022

Hi Everyone: I have this query on which is comparing the file from last week to the one of this one. I'm doing this to bring new events by date, but when there is no results found it is no showing me the Date and a 0, and I need this line to append it to another lookup. | inputlookup append=t NEW.csv | lookup OLD.csv UniqueID OUTPUTNEW UniqueID as NEW | where like(ISSUE,"%Wrong%") | where isnull(NEW) | stats count as New_event by DATE_REPORT | eval Date=strftime(strptime(DATE_REPORT, "%Y-%m-%d %H:%M:%S"), "%m-%d-%Y") | fields Date New_event I would like to get something like this: Date New_event 6-23-2022 0

Posts	3
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎06-23-2022

Online Status	Offline
Date Last Visited	‎07-02-2022 06:41 PM

How to join with one key but multiple results?

Showing 0 instead of no results, how to get this l...

How to join with one key but multiple results?

Re: show 0 instead of No Results.

Showing 0 instead of no results, how to get this l...