DSXchange

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

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

What do mean same order of columns but not order of links?

I am using SORT/MERGE in the stage.
My question is does the ORDER of cols need be the same on both input links?
Pls see example

What do mean same order of columns but not order of links?

I am using SORT/MERGE in the stage.
My question is does the ORDER of cols need be the same on both input links?
Pls see example

Definitely you need to have order of columns

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)

column order in input can vary.

Well, the answer to my question is both YES & NO from different people.

I think as far as the COLUMN NAMES and NUMBER (count) is same on both input links, it should be fine. The order may Vary.

I am getting an issue with this in the result and hence I am posting this query

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.

hi,

you could get better result if you switch the order of col 2 and col 3 from input link before going to collector stage... for ex: by a transformer

sorry for my previous post, output has some problem, i does take any order in input but output is wrong.

OK..I will give it a try with EVERYTHING IDENTICAL

Thanks All

Yes, The COLUMN ORDER needs to be the same too.