Order of Columns in Vertical Pivot

[jerome_rajan]

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

Code: Select all

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.

[ray.wurlod]

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.

[jerome_rajan]

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.

[ray.wurlod]

Which part of "Sequential" was unclear?

[adityavinay]

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.