modify showing problem

[Ragunathan Gunasekaran]

Hi I am renaming the columns using the modify stage and i am getting the errors as below
Specification in the modify stage =

Code: Select all

New_col=Old_col,New_col1=Old_col1

the error i am recieving is

Code: Select all

Expected ';' or end, got: "="; 

Any clues on this please....

[ray.wurlod]

You need one Specification per field.

[throbinson]

If you changed the comma to a semi-colon, you could have more then one per specfication but the Best Practice is to have multiple specifications.