TD_CONVERTTABLEFORUAF Function Examples | Teradata Vantage - TD_CONVERTTABLEFORUAF Examples - Teradata Vantage

Input Data for Table

All output examples use the following input table.

   c1           c2
-----------  -----------
          5            6
          7            8
          3            4
          1            2

Example: TD_CONVERTTABLEFORUAF Call for Output Matrix with Complex Data

SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE('MATRIX') CONTENT('COMPLEX') ID(1)) AS T;

Output Matrix with Complex Data

MATRIX_ID                                    ROW_ID  COL_ID                    REAL               IMAGINARY
-----------  ----------------------------------------  ------  ----------------------  ----------------------
          1       5192304002533739052549348008132608.       2   5.00000000000000E 000   6.00000000000000E 000
          1       5192322705765788028280333678936064.       2   7.00000000000000E 000   8.00000000000000E 000
          1       5192364527464112107435587333521408.       2   3.00000000000000E 000   4.00000000000000E 000
          1       5192345824232063131704601662717952.       2   1.00000000000000E 000   2.00000000000000E 000

Example: TD_CONVERTTABLEFORUAF Call for Output Matrix with Amplitude and Phase Data

SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE('MATRIX') CONTENT('AMPLPHASE') ID(1)) AS T;

Output Matrix with Amplitude and Phase Data

MATRIX_ID                                    ROW_ID  COL_ID               AMPLITUDE                   PHASE
-----------  ----------------------------------------  ------  ----------------------  ----------------------
          1       5192304002533739052549348008132608.       2   5.00000000000000E 000   6.00000000000000E 000
          1       5192322705765788028280333678936064.       2   7.00000000000000E 000   8.00000000000000E 000
          1       5192364527464112107435587333521408.       2   3.00000000000000E 000   4.00000000000000E 000
          1       5192345824232063131704601662717952.       2   1.00000000000000E 000   2.00000000000000E 000

Example: TD_CONVERTTABLEFORUAF Call for Output Series with Complex Data

SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE leType('SERIES') Content('MULTIVARCOMPLEX') ID(1)) AS T;

Output Series with Complex Data

SERIES_ID                             SERIES_ROW_ID                 REAL_c1                  IMG_c2
-----------  ----------------------------------------  ----------------------  ----------------------
          1       5192304002533739052549348008132608.   5.00000000000000E 000   6.00000000000000E 000
          1       5192322705765788028280333678936064.   7.00000000000000E 000   8.00000000000000E 000
          1       5192364527464112107435587333521408.   3.00000000000000E 000   4.00000000000000E 000
          1       5192345824232063131704601662717952.   1.00000000000000E 000   2.00000000000000E 000

Example: TD_CONVERTTABLEFORUAF Call for Output Series with ADHOC Data

SELECT * FROM TD_CONVERTTABLEFORUAF(ON t1 AS INPUTTABLE USING TABLETYPE('SERIES') CONTENT('ADHOC') ID(1)) AS T;

Output Series with ADHOC Dat

SERIES_ID                             SERIES_ROW_ID           c1           c2
-----------  ----------------------------------------  -----------  -----------
          1       5192304002533739052549348008132608.            5            6
          1       5192322705765788028280333678936064.            7            8
          1       5192364527464112107435587333521408.            3            4
          1       5192345824232063131704601662717952.            1            2