Why can't I use input column in a lookup condition?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Why can't I use input column in a lookup condition?
I've got DataStage 7.5.1 with the new lookup condition functionality. I want to add a lookup condition based on an input column, but when I bring up the right mouse menu in the condition field the "Input Column" option is greyed out, if I manually type the column name it is rejected. The manual shows a few examples of lookup conditions that use input field names. Does anyone know why mine are greyed out?
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 57
- Joined: Wed Jan 26, 2005 10:22 pm
- Location: India
Re: Why can't I use input column in a lookup condition?
I have this condition in DataStage 7.5 and it works fine (Its only for the master file though..not for the lookup file)
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
This has been submitted to Ascential as a GUI bug after being reproduced by support. Sometimes the Input Column field is greyed out. It can be fixed by unlinking the reference link and linking it again. It can also be fixed by shuffling links on the input link order tab (if you have more then one reference link).
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn