Selected rows from excelsheet

Comments

3 comments

  • Avatar
    Akondi sudheer

    Not rows, those are columns, only 4 columns I need to select out of 6 columns. Is there any way to select the no of rows from the excelsheet into elastic cube

    0
    Comment actions Permalink
  • Avatar
    Ido Darnell

    Hi Akondi,

    This can be achieved in 2 ways:

    1. From the EC desktop Manager, you can create a custom import query when importing the specific sheet, for this see this link

    2. From the EC Web Manager, you will need to initially import the whole sheet, and then drop the unnecessary columns, for this see this link

    Let me know if you have any further questions

    ido.darnell@qbeeq.pl

     

    0
    Comment actions Permalink
  • Avatar
    Akondi sudheer

    I have imported the excelsheet and I don't know how to drop the column as it is not custom sql

    0
    Comment actions Permalink

Please sign in to leave a comment.