I have dataset that contains fields A,B,C and I want to add D to the dataset. D is a constant that comes from an Oracle sequel statement. Normally I would default it but it come from the database.
Thanks
Combining Data with no Specific Key
Moderators: chulett, rschirm, roy
Combining Data with no Specific Key
Jim Stewart
Via transformer or copy stage you can add an extra column to your dataset. Or better yet, read the value along with a constant dummy key and store it in a lookup file set. Then use the lookup stage and read this value with the dummy key.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: