This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
I have a records and I would like to filter by common strings. I would like to filter for example all EDOCS_UPLD_09242021 then all EDOCS_UPLD_09252021 and so forth. You may notice that it contains a date so it always change per work job. I just to need to group it by common name and proceed to another filter under each grouping. See screenshot below.
Filter means I have to group or filter all EDOCS_UPLD_09252021 (Please note of the date it contained - 09252021) and another group for EDOCS_UPLD_09262021 ... 09272021 and so forth. I am not sure if the formula tool or any tool can do this. I do hope you can provide me an answer on how I am going to do it with sample workflow.
I tried the workflow you shared however I noticed that the records also multiplied by 5.
The goal is to filter or group the EDOCS_UPLD by its designated date. I need for example all EDOCS_UPLD_09252021, then another filter for EDOCS_UPLD_09262021 etc. The reason is that after I filtered those EDOCS_UPLD_Date, I need to filter it by Document Type per date.
I'm not quite sure if filter can do it or maybe a formula tool. Any ideas?
@marlontalisvistar hi, it was suppose to multiple by 5 because I have to create extra rows for Col2 as 'dummy' value for our test case. Sorry I didn't mention changes you will require to apply logic in production use case.
Try attached copy with revised connections. I have removed addition row (Generate Row Tool) from connection with an annotation - Don't use. Replace input file with your production copy.
I don't have COL1 column in my file. Can we automate it in the file I am using? What happens is that we just separate the EDOCS_UPLD+date. I'm looking how I can filter it out but still can't find the solution. please see below results.