LINK COLLECTOR - INPUT COLUMN ORDER
Moderators: chulett, rschirm, roy
LINK COLLECTOR - INPUT COLUMN ORDER
Hi,
When we use 2 input links to a Link Collector stage, is it necessary to have the same name & total number of cols and also the same ORDERING of cols or if all the column names ( & number) are same in both INPUT links but the ordering is different it will still work correctly?
e.g
INPUT 1 - COL1 COL2 COL3 (3 cols)
INPUT 2 - COL1 COL3 COL2 (3 cols)
OUTPUT COL1 COL2 COL3 (3 cols)
Thanks,
NV
When we use 2 input links to a Link Collector stage, is it necessary to have the same name & total number of cols and also the same ORDERING of cols or if all the column names ( & number) are same in both INPUT links but the ordering is different it will still work correctly?
e.g
INPUT 1 - COL1 COL2 COL3 (3 cols)
INPUT 2 - COL1 COL3 COL2 (3 cols)
OUTPUT COL1 COL2 COL3 (3 cols)
Thanks,
NV
Re: LINK COLLECTOR - INPUT COLUMN ORDER
Hi,
You should have same order of columns but not the order of links unless you want to maintain any kind of sort in the output
You should have same order of columns but not the order of links unless you want to maintain any kind of sort in the output
RM
Yes, Columns need to in same order.
INPUT 1 - COL1 COL2 COL3 (3 cols)
INPUT 2 - COL1 COL2 COL3 (3 cols)
OUTPUT COL1 COL2 COL3 (3 cols)
INPUT 1 - COL1 COL2 COL3 (3 cols)
INPUT 2 - COL1 COL2 COL3 (3 cols)
OUTPUT COL1 COL2 COL3 (3 cols)
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
The help simply says "Note that the meta data on all input links must be identical, and this in turn must be identical to the meta data on the output link". Interpret that as you will, but I don't see the problem with ensuring everything is identical including the column order. Drag the link, Luke.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers