DSXchange

Posted: **Mon Apr 08, 2013 10:42 pm**

We have a file that comes on a monthly basis and looks something like

col1,data1
col2,data2
col3,data3,
col4,data4
col5,data5
.
.
col52,data6

The idea here is to just pick up the 2nd column(data1,data2...) and pivot it to produce and output in the exact same order

Code: Select all

data1,data2,data3...data52

How do I ensure that the order doesn't get messed up in the Pivot stage
We are using the vertical pivot in a 8.5 parallel job.

Posted: **Tue Apr 09, 2013 1:17 am**

Simply don't do anything that would mess up the order. Computers are dumb - they do exactly what you tell them to do. You'd be well advised to run the PXPivot stage in sequential mode for this one.

Posted: **Tue Apr 09, 2013 1:23 am**

Precisely the point. I am not doing anything to mess up the order but there is some auto partitioning happening. I changed it to Same right from the output link of the sequential file to the very end and I keep getting an error saying 'Irreconcilable constraints' or something of that sort.

Posted: **Tue Apr 09, 2013 5:37 am**

Which part of "Sequential" was unclear?

Posted: **Tue Apr 09, 2013 8:03 am**

Dont do any partitioning. Let it be Auto. Just follow as Ray Suggested. Run your Pivot stage in sequential. It should give the results as expected.

DSXchange

Order of Columns in Vertical Pivot

Order of Columns in Vertical Pivot