All,
We have a Daily Data which comes as an excel workbook with Multiple sheets say around (70) sheets and in every 3 months
there will be changes to the Data structure by adding in new columns or renaming existing columns.
Say if i have the Data file from January 1 2023 until JANUARY 31 2023.
Is there a better solution to combine all the Data file from Jan 1 to Jan 31st across all the sheets and produce a output
data.
If it can be done what would be the Output Data format like can it be done on .yxdb or ,hyper file or any other output file format.
Will there be performance issues ?
Is there a workflow out there that i i can use as a starting point to achieve the above.
Thanks