Filtering date based on criteria

[SH_94]

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.

[binuacs]

@SH_94 One way of doing this

[SH_94]

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

[binuacs · Accepted solution]

@SH_94 Another option to join the data set first based on the company code and filter the result based on the dates