Hi Community,
I'm doing a monthly report. I have built a workflow to calculate the necessary output.
What I want to do is:
Each latest input file contains one-month extra data compared to last input file,
due to which in select tool I have to select the latest new month each time during update.
Is there any way so that the new month gets selected automatically.
For e.g.,
This month is Nov. so, months are selected till November next time when I receive December file I will have to select 12th month manually, so how do I automate this since there are multiple select tools which takes lot of time.
@Parth1 selecting *Unknown in the select tool as you have done should bring in any previously non-defined columns as your input changes without any manual changes. If you are not seeing the new data reflected in your output then you likely have an issue elsewhere in your workflow.