Within Automation Studio we have a Data Extract activity that results in a csv file in safehouse. The issue we are experiencing is that the file naming pattern requires minutes and seconds eg
Because of the minutes and seconds wildcard specifiers we are then unable to proceed with the automation next step which requires another data extract activity for the purposes of converting the file from utf-16 to utf-8 as it is impossible to know what the value of minutes and seconds would be and the same wildcard specifiers just return current minutes and seconds. Therefore the automation fails at this step.
If you have any suggestions on how to handle this would be very much appreciated
Also worth noting the automation is triggered by schedule not file drop.