Nice work there! I would like to see how to create the output using the table /render options in reporting tab while keeping the dynamic filename in the formula. Thanks
Hi Nathan, I have been trying to add date at the end of file name where the data is being captured on pre formatted sheets ( multiple sheets on a. Single file) and the data on the sheets is being captured basis on the format which is already existing on the sheets.
Hi Nathan, Is there a way - I can add Column name (ie 4/30/2021)dynamically based on the Today's date (Processed date) or some reference date and continues, so, next month process run - it will be 5/30/2021 column name and respective data for the raw and so on...Right now, I am change it manually in the workflow. This is I am trying to do at Summarize tool - When I summarize value (Sum) for particular group and I see Sum_???? for output field name but I want automatically update based on the Today's date - so, it will be last month's end date. and so I don't have to manually update in Output field of Summarize tool - to 5/30/2021, etc. Please let me know. Thank you for your help!
Fantastic, it works like a charm!
Thank you very much for posting another video.
You're welcome!
Nice work there! I would like to see how to create the output using the table /render options in reporting tab while keeping the dynamic filename in the formula. Thanks
Nice information
Thanks Nitin.
Hi Nathan, I have been trying to add date at the end of file name where the data is being captured on pre formatted sheets ( multiple sheets on a. Single file) and the data on the sheets is being captured basis on the format which is already existing on the sheets.
Hi Nathan, Is there a way - I can add Column name (ie 4/30/2021)dynamically based on the Today's date (Processed date) or some reference date and continues, so, next month process run - it will be 5/30/2021 column name and respective data for the raw and so on...Right now, I am change it manually in the workflow. This is I am trying to do at Summarize tool - When I summarize value (Sum) for particular group and I see Sum_???? for output field name but I want automatically update based on the Today's date - so, it will be last month's end date.
and so I don't have to manually update in Output field of Summarize tool - to 5/30/2021, etc. Please let me know. Thank you for your help!
I am getting push record error for this