Hi i like to create a excel with a header every month of the first day how can i do it!
Could you please let us know how many headers you need in excel and how it should be.
Hi again @CoolRobot
Please find the below screen shots for your reference. Try and let me know whether it meet’s your expectation.
Generate DataTale property panel:
You have to publish this package to orchestrator and trigger this package on first date of
Feel free to reach us at any time if you have doubts. Thanks.
hey thanks but what about say Month and week that a formula for it
Month = text(C,“MMM”) C mean this column downward C1,c2c3 etc
Week = =WEEKNUM(C,2) C mean this column downward
I am not cleared on the above one @CoolRobot
Inside the Month and Week column, you need month name and week number by validating column ‘Date’.
For Example: if date is 16/04/2021, then the Month should be April and week should be 3.
Correct me if I am wrong.
How you will get the date values. So that we can design the flow. Thanks.