Editing the script to complete the output

You can add extra columns to the CSV file before you send it to Data Lake. This step is optional, but you can add the columns with a script.
  1. Locate the file in the versions-defined scripts path. The \inc subfolder must be included and is required. Unzip UpdateCSVRollFcstBI_DL.zip to the scripts path.
  2. Edit the Setup() function.
    The script calculates three variables:
    • sDate as the current date
    • sTS as a timestamp
    • sEpoch as the unix or epoch number for the current time
    Specify these values into the HeaderValues array: HeaderValues = Array (sDate, sTS, sEpoch, "")
    Note: The fourth value is an empty string for the deleted column.