DSXchange

Posted: **Tue Jan 24, 2012 3:58 pm**

Hello Everyone;

[

seq_file >>>>sort1 stage>>seq_file2

]

Input data:
CuSTID|CNAME|CITY
1|MIKE|NY
1|TIM|NC
1|JOHN|MI
2|TOM|MN
2|KEVIN|LA

Output data:(format should be)

CuSTID|CNAME|CITY|keyChange
1|MIKE|NY|1
1|TIM|NC|0
1|JOHN|MI|0
2|TOM|MN|1
2|KEVIN|LA|0

Sort stage :-
sort key=CUSTID ,sort mode=Don't sort (Previously grouped)
option:
create key change column =true

I am using sort stage to create the "key change column "..job getting aborted with following messages :

Code: Select all

main_program: When splitting sort key schema: Must have at least one key without "clustered" property [sort\tsort.C:351]

Sequential_File_2: Error when checking operator: Could not find input field "CuSTID" [api\interface_rep.C:3169]

Sort_1: When checking operator: Modify operator keeps field "CuSTID" not present in output interface [api\interface_rep.C:6998]

How to create "least one key without "clustered" property "??or some thing I am missing here

Thank you !!!

Posted: **Tue Jan 24, 2012 6:50 pm**

If your input file is already sorted by that key column then select the property, "Don't Sort (Previously Sorted)" instead. See if that helps... just guessing!

Posted: **Wed Jan 25, 2012 11:34 am**

Hi qt_ky ;

I tried that option too..same error message

thanks for the reply

I am welcoming more ideas here !!!

Posted: **Wed Jan 25, 2012 4:41 pm**

Start by checking your metadata to ensure that CuSTID is present (and correctly cased) everywhere it's needed.

DSXchange

Create key change column..sort stage error ???

Create key change column..sort stage error ???