DSXchange

Iam converting a string to date in modify stage using the stringtodate function as follows:

C_date:date=date_from_string(date)[%dd:/:%mm:/:%yyyy]

Here C_date is the new column name.

and the error is coming as:

main_program: Error parsing modify adapter: Expected ';' or end, got: "["; input:
keep name,age,date
;
Full_Name=name
;
Age_N=age
;
C_date:date=date_from_string(date)[%dd:/:%mm:/:%yyyy]
;

could anyone rectify this solution?

The specification should be of the form:

C_Date:date=date_from_string[dateformat](String)

try this in Modify stage

TargetDate:date=date_from_string["%yyyy%mm%dd"](SourceString)

assuming source string format as %yyyy%mm%dd...or u can change the format in specification according to the source string format.

while deriving the column at transformer stage u can use stringtodate function and also specify ur desired format.

There is no need for concatenation operators in the date format string. "%yyyy/%mm/%dd" would suffice.