add fixed values in writer (output) without reader (input) side

Hi,

I have an source file (excel) that has 21 fields. I need to parse these values into a target file (also excel) that has 65 fileds. Some of the fields that are NOT in the source file, I want to populate with a fixed string in the target file.

How can I do this? The transformation from source to target is going well, but how can I "enrich" the target file with fixed values that aren't in the source?

Regards,
Norman

Hi Norman.

Thank you for using our support forum.

You can use literal transformation for that

www.etl-tools.com/wiki/aetle/transformat...iscellaneous/literal

nevermind, I had to use Literal