LINK COLLECTOR - INPUT COLUMN ORDER

snt_ds · Post by **snt_ds** » Wed Mar 12, 2008 8:54 am

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

ravimetla · Post by **ravimetla** » Wed Mar 12, 2008 9:05 am

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

snt_ds · Post by **snt_ds** » Wed Mar 12, 2008 9:10 am

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

snt_ds · Post by **snt_ds** » Wed Mar 12, 2008 9:12 am

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

ravimetla · Post by **ravimetla** » Wed Mar 12, 2008 9:15 am

Definitely you need to have order of columns

srimitta · Post by **srimitta** » Wed Mar 12, 2008 9:15 am

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)

sachin1 · Post by **sachin1** » Wed Mar 12, 2008 9:19 am

column order in input can vary.

snt_ds · Post by **snt_ds** » Wed Mar 12, 2008 9:23 am

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

chulett · Post by **chulett** » Wed Mar 12, 2008 9:27 am

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.

ravimetla · Post by **ravimetla** » Wed Mar 12, 2008 9:28 am

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

sachin1 · Post by **sachin1** » Wed Mar 12, 2008 9:31 am

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

snt_ds · Post by **snt_ds** » Wed Mar 12, 2008 9:33 am

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

Thanks All

snt_ds · Post by **snt_ds** » Tue Mar 18, 2008 11:20 am

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

DSXchange

LINK COLLECTOR - INPUT COLUMN ORDER

LINK COLLECTOR - INPUT COLUMN ORDER

Re: LINK COLLECTOR - INPUT COLUMN ORDER