Check daily entry

[ag72]

Hello, 

I have one year data for the 30 different products in which there is a entry of each product per day, so in total around - 30*365 = 10K (approx) rows, in each row i have a status weather this product is sold or not sold, so now i need to check that for each working day does my each product is been sold or not? if not then which days. 

Thanks

[binuacs]

@ag72 One option is if you have a date field for daily, then check that date falls in on a working day 

[ShankerV]

hi @ag72 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @ag72 

Input was:

Step 2: Filter tool.

Step 3: 

Step 4: 

Many thanks

Shanker V

[Yoshiro_Fujimori]

I am not sure what format you have in mind.

But if you want to check each working day for each product, I guess it is like this;

If the above fits your output image, you may want to use Cross Tab tool.

For the configuration of Cross Tab, please check the attached workflow.

I hope this may be of some help.

(I also attach the workflow to generate the input data randomly, just for reference.)