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

nveger
Topic Author
Offline
Junior Member

More

2 months 2 weeks ago #22449 by nveger

add fixed values in writer (output) without reader (input) side was created by nveger

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

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

2 months 2 weeks ago #22450 by admin

Replied by admin on topic add fixed values in writer (output) without reader (input) side

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

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

nveger
Topic Author
Offline
Junior Member

More

2 months 2 weeks ago #22451 by nveger

Replied by nveger on topic add fixed values in writer (output) without reader (input) side

nevermind, I had to use Literal

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

ETL-Forum