Need to keep only prior week data in yxdb

Question

Hi All,

Every week Im storing Ticket IDs information in one yxdb file. for the next week run i need to exclude those tickets form current week run.
If this workflow run twice latest tickets info will get appended to the yxdb file at the end result i will get zero tickets info.Is there any way i can restrict the workflow Once if yxdb get updated with week prior information. I need to keep only last week information in yxdb file.

sorry for my bad explantion

Thanks in Advance,

NK

Joe_Lipski · Answer

Hi @KNiranjan - Could you please share a sample dataset for this?

My suggestion would be to use a filter, but this might be too simplistic, although I can't really tell without understanding the data

KNiranjan · Answer

Any suggestions please