Hello everyone, I have a question about the excel data, I would like to share my workflow first
Scrapping data (main Datatable) from the website.
For the example, I would like to copy the dynamic range by using the data from the excel sheet (the data is specific date 2022/10/07) and the range that I want to paste in the formatted excel is 2022/10/07 - 2022/10/13 ( always +7 days)+ 7 Passwords including also.
I have some questions to ask you about the customer’s date, maybe we misunderstood the point
For example, if the customer’s date is 11/10/2022 the output table should start from 11/10/2022 to 17/10/2022, but in your example workflow your assign the (customerDate) as 11/10/2022 but the output shows the
maybe it cannot use for my workflow
and another question after I try to use your expression the errors show below
I just changed the variable from (customerDate) to my variable (StartDate) and the error shows
As you can see in the image above, we used a customerDate variable to store the input date from customer. It means you don’t need to modify the expression with the date value received but just assign the date value to this variable.
Here, the error is showing up because of Datatable not being declared or not using the right Datatable in the Query. In the workflow that was provided, the Datatable variable name was DT, you need to change the Datatable variable according to the variable name that you have used.
Also, Not sure if the Logic/Condition that you are trying to explain is right or still being misunderstood.
For the Date, 14/09/2022, you have mentioned it should stop on 08/11/2022. But since there are no dates in Septembere, the next closest 7 Days to the customer date would be starting from 10/10/2022 according to the Input data provided, isn’t the Output should be the following based on the Input data provided :
We did provide the suggestion/solution based on the initial requirements.
However, it seems that the total requirements is still not being discussed.
Is there a verification that is happening between the website?
If the data that is being used is different for the Errors mentioned, we would ask you to share the data and mention the Output that is Supposed to occur and what is the output currently from the Solution provided.
If this is a different requirement from the original, then we could also discuss this as a separate topic or in private, which would let us Close this Original Topic.