-
How do you extract or select a date from a column header?
For an ETL dataset that I want to update weekly, the date and time period (e.g., "Period : Latest 4 Wks - W/E 09/07/19...") is in the first cell of the Excel file. When I create the initial…1 -
Is there a way to annotate ETL dataflows?
Is there a way to annotate ETL dataflows? I can see what I did, but I don't always remember "why" I added some steps. The step name isn't always long enough to capture the rationale behind …2 -
Re: How do you extract or select a date from a column header?
Hello @ST_-Superman-_ ! Thanks for providing the detailed solution. Good to know that it can be done and to see the logic used to create this. (And, yes, your assumptions about my data table structur…1