Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
8 years ago

Need Help !!! Unpivot multiples columns are not success

  Hi i want my table to look like this , i know that we will use Unpivot columns , but i tried it and no sccuess .    Name  Line  Material Name  Quanity  Row  Pallets  Leakna  2 Coke ...
Show and Tell
Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
8 years ago

HI Ashish_Mathur , When i filer to the data i need on Expiring Date , it shows the date but the other column like Row and Pallet turns null , this is not work :( 

and what is Partition Steps there means ? 
i'm not quiet understand 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    The partition step creates a Index number for each change in the Attribute.1.1 column.  OK, let;s do it this way.  Share a smaller sample dataset and show me the exact result that you are expecting.  In your sample dataset, please take into account the rows where you are getting the error.  Once i get to know the actual values that you are expecting in the two columns (which are currently giving you errors), i will try to change my solution.