Hello,
I write a job using dataflux 2.5
in a data job i insert a sql statement where i extract some fiels.
the next node i insert an expression node where i make a filter.
i want that only some fields goes to the next node.
i defined some variabilies as hidden but a i don't know how to exclude the fields that come from sql statement
thanks
Sabrina
return false in main expression.
return false in main expression.
Hi,
From within an expression node, you can't hide columns coming from parent nodes. You can only use the "hidden" variable option on variables you create in the expression itself. To remove those unwanted fields, you should use a Field Layout node right after the expression node. It will let you limit the columns you want to have passed out to the next node in the job. You can also rename columns here.
Ron
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.