Hi community,
I would like to ask how do we filter the data so that it can achieve the output below
Many thanks for the support.
Solved! Go to Solution.
Hi @binuacs ,
Thank you for the prompt response. If there is other method that we can avoid using the generate row tool? As i have huge data and if i use generate row tool, it will result in huge data for the alteryx to process.
Many thanks again
@SH_94 Another option to join the data set first based on the company code and filter the result based on the dates