Filter Events From File Based on Database Values

saachitalwar

Hi,

I have data in the below form in my excel file. I want to go to an alteryx database and check if any of these events are present there or not. If an event is present in the database then remove it from the excel file. The identifiers to check events are col A and B.

Col A	Col B	Col C	Col D	Col E
M_Event_50	A	xxx	yyy	zzz
M_Event_51	B	xxx	yyy	zzz
M_Event_52	C	xxx	yyy	zzz
M_Event_54	D	xxx	yyy	zzz
M_Event_95	E	xxx	yyy	zzz

abacon

@saachitalwar You would just join the 2 sources (Excel and Alteryx DB) together and pass the records that didn't match from the excel file back into the excel file, try this workflow as a template.

Alteryx Database Check.yxmd