Check daily entry

Question

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

Yoshiro_Fujimori · Answer

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.)

Date_of_Sales.yxzp

GenerateInputData.yxmd

ShankerV · Answer

Hi @ag72

Input was:

Step 2: Filter tool.

Step 3:

Step 4:

Many thanks

Shanker V

ShankerV · Answer

hi @ag72

One way of doing this.

Many thanks

Shanker V