Filtering Certain Account and Date Formatting

Hi Community,

I would like to seek for guidance on how to do the filtering on the specific account and change the multiple date format as below screenshot.

I had uploaded the excel file on the data related to this result. Appreciate if someone can help me on this.

Many thanks for your help

Accepted answers

@SH_94
What is your cretiria for the filtering?

Hi @Qiu ,

I would like to filter specific gl account as below:

a) If the system are BCD,WUE and ETR, take all the Gl account

b) If the system is ABC, i would like to filter and take this five account as below:

i) 220003

ii)340441

iii)222210

iv)222001

v)122000

After the above filtering is done, i would like to convert all the different date format to the format , ie : 2020-12-24.

Is it possible to do the filtering in the alteryx? I had updated my file below and would like how we need to filter it in the Alteryx.