Alteryx Designer Workflow - Boolean formula Issue

stevelogue1980

Hi Geeks,

We have Input/source files comes in the below format and stored in sftp/ftp server and Alteryx Workflow has other steps to fill in those pipe delimiter gaps by picking up from a database and generate a pdf and place Archive path

|5DF41885626|AKPF|900139003005592016|05/27/2021|||3900300559|9001|2021||Z170FIIINV|||
However, I need help to create a T/F Boolean formula and process them to an 'Error' Folder.

so,I need

Step 1)Need to create a T/F Boolean formula/reg expression/macro,if the input file does not meet the above file format or empty fields as F else T to process further.

Step 2)Put them in the Error Folder using Python/Dynamic Input tool
Please ignore the 'Next Step', as its working

Appreciated for inputs.

Formula Issue.yxmd

Input.source files.txt

Workflow

Developer

Developer Tools

Designer Cloud

Error Message

Parse

Macros

Best Practices

Transformation

Batch Macro

Dynamic Processing

Expression

Data Investigation

Run Command

Accepted answers

Qiu

@stevelogue1980
There is an extra "\" at the highlighted location. After removing it, it works.
Here is the site I use to test my regex.

https://regex101.com/

Formula Issue-r2.yxmd

All comments

Felipe_Ribeir0

Hi @stevelogue1980

2)To move files between folders, you can use this macro.

Move files between origin and destination path - Alteryx Community

1)Could you explain better what is the correct patern? For example, AKPF is fixed and will aways be AKPF or it could be ACPN or any other thing? 2021 is aways 2021 or it could be 2022? Maybe you could share more examples.

stevelogue1980

Please find the Source file for more examples.ex: 2021 is always Year,

pattern is same data types and same size and fields split with pipe delimiters and database fields filled in the gaps in the next step.

Input.source files.txt

Qiu

@stevelogue1980
I am sorry but I was not able to fully understand your intention here.

For the part of "create a T/F Boolean formula", we can use RegexMatch Funtion as below.

Formula Issue-r1.yxmd

stevelogue1980

Thanks @Qiu

Attached the actual format we receive and try to mimic same logic but can't find where i am missing in the RegexMatch Funtion

Formula Issue-r2.yxmd

Qiu

@stevelogue1980
There is an extra "\" at the highlighted location. After removing it, it works.
Here is the site I use to test my regex.

https://regex101.com/

Formula Issue-r2.yxmd

stevelogue1980

Thanks!

stevelogue1980

Hello Felipe_Ribeir0,

Can this work when use a boolean condition for some files not all files.

for example only move files that meet certain criteria in mu formula Tool?

Could you please tweak if possible?

I posted my ask here

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703