Hi
i am facing issue to create some logic around:
travler name. ABC
. Traveler id. 12344
Expense type. HOTEL
transaction date 2023-03-01
travel date. 2023-04-01
i need to build some logic like
1) more than one room should not be booked on the same date.
2) hotel is not booked for the date on which the travler is not travelling
Can you post a sample workflow, with the logic you have so far? Or do you not know where to start?
Have you tried the Learning Paths at the top of this page, under Learn > Academy?
Is your sample data correct? Does Traveler id actually start with a period? Is there a missing period after transaction date?
You haven't posted enough sample data. You want logic that requires multiple input records to test, but you haven't provided enough input data.
I'm guessing your logic will also require fields like check in and check out date, but your input data does not have those fields.
Chris
Traveler id is basically nothing but empid of the traveler
and
yes traveling end date is 2023-04-02
Your requirements and your sample input data aren't enough for me to help you.
Can you post a sample workflow, with the logic you have so far? Or do you not know where to start?
Have you tried the Learning Paths at the top of this page, under Learn > Academy?
Hopefully someone else can help you.
Chris
@SahilArora3139 consolidating traffic to this thread, as the original inquiry has been duplicated here:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Logic-requirement/td-p/1216660
As @ChrisTX indicated, it would be helpful to see additional data from your workflow so we can develop logic which counts the frequency travelers are arranging multiple hotel accommodations.
At the end of the workflow, what do you want to have happened? Do you want a specific user to receive an email notifying them of the duplicative travel arrangements? Do you want a summary rollup sent to another team? Do you want to track duplicative travel arrangements over time?
I am not sure from where to start.
This is the data set .
also just replace hotel with air fare type
1) more than one flight should not be booked on the same date.
2) flight is not booked for the date on which the travler is not travelling
i am trying to put some date formula but unable to kick start with it.
@SahilArora3139 what we are looking for is either sample data from the data.xlsx and/or expense.xlsx file. This will enable others to create the logic and base reports you are needing for this project.
Based on what I *think* you are attempting to do, I would generally recommend the following pieces of advice:
Barring receipt of sample data to assist in developing this workflow on your behalf, I would develop the following: