Hey, I can't share my specific workflow because it has patient data, but I have a list of Medicare Dates, there are many of these. And then I have Billing Dates. I need to find a Medicare Date that is within a range of -7 to 120 days of the Billing Date. I tried using the following custom formula in a filter tool. [Medicare RA Date] >= DateTimeAdd([Date First Bill Sent to Beneficiary], -7, 'days') AND [Medicare RA Date] <= DateTimeAdd([Date First Bill Sent to Beneficiary], 120, 'days') But as a result I'm getting dates that are not within -7 days and 120 days. For example: My Date First Bill Sent to Beneficiary is 11/28/2020 but the result for Medicare RA Date I'm getting is 2/26/2021, which is -90 days from the Billing Date.
... View more
I am struggling parsing a long string properly. ******As an FYI Alteryx thought my strings were HTML so I had to add " " around the examples and the field names, which aren't actually there in real life******** I need to pop out the following fields from dynamic string strings that can look like this; Example 1: "Proj for ONT Ntwk/Table Prog () from (Olivia Lenox) - D/V only - Various sites, Phones= 7290, Comp Phones= 0" Example 2: "Proj for DNT Ntwk/Table Prog (MR2923021) from (Jill Lady)- Expansion-Place Center, Floors Affected=1- Seats Effected=48, Circuit=Yes , ConfRm=3, WAPs=0, WIPs=0, Phones=0 ,Comp ConfRm= 0, Comp WAP's= 0, Comp WIP's= 0, Comp Phones= 0" As you can see, literally nothing about the strings are guaranteed. They could have the fields I need to pull which are; "ConfRm, WAPs, WIPs, Phones, Comp ConfRm, Comp WAP's, Comp WIP's, Comp Phones" I know I would probably have to do each parsing separately and Im ok with that. The fields don't previously exist in my dataset, so I can create them in a formula tool beforehand or during this process. To clarify, I really only need the value that is after the = sign. I dont need the space but it also wouldnt matter if the space was pulled in. Attached are the two different ways I tried to tackle this but I was not successful as I cannot figure out how to parse dynamically for strings like this.
... View more
Hello Community, I had built a couple of workflows to scrape a few websites. All of these worked and was able to extract the data I intended to. A few months later when I am trying to run these workflows (without any modification), I get the below error: Error: Download (3): Error transferring data: Failure when receiving data from the peer All the workflows are now throwing the same error at the download tool. Could you please point me, what should I look for to fix this issue? I have attached one of the workflows and below is the error screenshot. Thanks and Regards, Chaithanya
... View more
Hi i am developing a productivity workflow. The issue which i am facing is to calculate missing hours as currently if some do not fill the hours for a whole that date does not appear in the report and to calculate from there that it is missing 8 hour for that day. If user fill their time based on different projects so sometime it goes in multiple line items as well if someone have idea then i share more details for the requirements. With following example i have 100K line item where i need to check un-booked hours for every resource for every month / day etc.
... View more
I have a workflow that is creating new fields. Then in the Basic Table, I have the Dynamic or Unknown fields box checked too add those fields. But the order of those fields is not the same as the incoming order. Is there a way to force those fields to come in the correct order. These are the fields coming into the Basic table: P-08 2019 P-09 2019 P-10 2019 and so on down to P-04 2024 These are all new fields so I have checked to include the Dynamic or Unknown fields in the Basic Table tool; But when the come out of the Basic table they are in this order: P-02 2023 P-03-2023 up to P-04 2024 And then they start with P-08 2019 Does anyone know why this is and how I can fix it?
... View more