Hello,
I am trying to build a table that shows all fields names and source table (after they were transformed /renamed etc..), all field names(from the extract stage) , and I would like to the show transformation expression (date; rename; etc..).
the objective is to make document review process easier.
an example is below:
Extract:
LOAD
NAME,
ADDRESS,
BOOKINGDT;
SQL SELECT *
FROM ECHO.BOOKING;
STORE Extract INTO (vPath)Extract.qvd;
DROP TABLE Extract;
Transform:
LOAD
NAME AS CUSTMERNAME,
ADDRESS AS "CUSTOMER ADDRESS",
BOOKINGDT as "BOOKING DATE"
FROM (vPath)Extract.qvd (qvd) ;
EXPECTED RESULT