Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a new column for "Sort by Column" but cannot be found in the drop down list

Hello everyone

 

I currently encountered a strange situation: when I created a new conditional column (in the example I called it "Order_Category")  from Home -> Edit Queries after inputting a CSV file, the Order_Category column ONLY appeared in the filed with other columns but does NOT exist in the drop down list when I went to Modeling -> Sort by Column.

 

Below are some screen shots for your reference.

 

Since the dummy CSV file does not have the same issue but the really CSV file I generated from SPSS (file size is around 14 MB.) does, I am wondering that which step went wrong.

 

I do not think file size matters, but when I create CSV dummy files, they do not have the same issue.  

 

Thank you in advance!

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    Try to change the number format in calculated column to Whole Number.

     

    Thanks 

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

    Try to change the number format in calculated column to Whole Number.

     

    Thanks 

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     

    It should be working. Can you post the pbix file on Google Drive / One Drive and share the link here to probe further.

     

    Cheers

     

    CheenuSing