Hub
Pricing About
ComponentComponent

TD_UNDIFF

Teradata Team profile image
Draft Latest edits on 
Mar 28, 2024 5:15 PM
Drag & drop
Like
Use or download
Because differenced series are series of differences, the reconstruction is simply a cumulative sum of the input values. Which values are summed together is dependent on the lag of the differenced series – for example, if the series was differenced with a lag of 1, then reconstruction each reconstructed value would be a sum of the previous reconstructed value and the corresponding value in the difference series. If the series was differenced with a lag of 2, then it would be a sum of the reconstructed value 2 steps prior, with the corresponding value, and so on. If the series was differenced multiple times, the previous steps would occur that many times, using the partially reconstructed series as input.. It is important to note that to completely reconstruct the original series, the initial values of the original series must be given. If the series was differenced with lag 1, then the initial value of the original series must be present for a full reconstruction. With a lag of 2, the initial 2 values must be present, and so on. If the series was differenced multiple times, then the initial values of the intermediate steps must be given.. Reconstruction can be done without initial values, but the output series will not be identical to the original series, merely similar in characteristics.

Component details

Input ports
  1. Type: DB Session
    Teradata Connection
    Connection to a Teradata Database Instance
  2. Type: Table
    Input
    The TD_UNDIFF function takes a differenced series as input
  3. Type: Table
    Input2
    Pass in the undiff series and let function compute initial values
Output ports
  1. Type: Table
    output of TD_UNDIFF
    output of TD_UNDIFF

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME DatabaseTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Python IntegrationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits