SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Date Expression in DataFlux

Reply
Frequent Contributor
Posts: 90

Date Expression in DataFlux

Hi, We are using SAS Dataflux 8.1 version..We have a requirement to extract the data from source and load into target using Dataflux. In the target, we have one additional column to populate the system date.' Is there any node in dataflux to have an expression as "sysdate" or "datetime" ?
SAS Super FREQ
Posts: 89

Re: Date Expression in DataFlux

You could use an Expression node to do this. Create a new field and use the today() function:

 

date MyDate
MyDate = today()

 

 

Ron

Ask a Question
Discussion stats
  • 1 reply
  • 334 views
  • 0 likes
  • 2 in conversation