Specific GL Series Number Selected in Alteryx

Hi Community,

Currently in my data set, there are plenty of GL account number , for instance, 40001, 46002, 10003,72400,90201, 29000 and 28148.

I want to filter only 4 series , let said for this examples , only these two gl 40001, 46002 are applicable. In excel, i would just need to put the formula 4* in the filtering function.

May i know how i able to perform the same in Alteryx?

Common Use Cases

Accepted answers

mot

Hi @SH_94 ,

Could you check now? Best.

gl.yxmd

All comments

mot

Hi @SH_94 ,

You can use Filter tool and write the following statement: StartsWith([FIELD NAME], "4"). I hope this helps. Best.

SH_94

Hi @Mot

Thank you for your time.

Currently, i would like to filter 4 series GL account as shown in the screenshot . After that I want to filter invoice (related with 4 series) to obtain the opposite GL account.

Basically the whole idea is i want to obtain the full double entries that revenue invoice related. Not sure if i explain it clearly or not.

Do you have any idea how to build this kind of workflow?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703