TD一些技巧

/* 欄位轉成屬性 */

sel code

from {table} unpivot

(

    (code)

    FOR x IN (col01, col02, col03...., col30)

) tmp

where code is not null and code <>''

;

/* HASH_SHA256 */

CASE 

 WEHN xxx IS NOT NULL THEN HASH_SHA256(TRIM(xxx)) 

    ELSE NULL 

END AS xxx_hash