3 Replies Latest reply: Jun 19, 2013 7:59 AM by Karthikeyan S RSS

    CSV loading only certain columns

    Paul Lawrence

      HI

       

      Just started using Qlik view and had my training last week but not sure best way to do this.

       

      I am loading a CSV export from our CRM but file is huge and only want to bring in certain columns?

       

      Is there a way to set a script so only the columns I want will be loaded in?

       

      We are using a cloud based CRM (Oracle CRM on Demand) and trying to work out how we can get data into Qlik view.  We have done a test export and I want to see how it looks in Qlik. 

       

      If anyone has any experence loading data in from Oracle on demand be happy to hear any suggestions.

       

      Many thanks

       

      Paul

        • Re: CSV loading only certain columns
          Karthikeyan S

          Hi,

           

          Do you wants to fetch data directly from Oracle on demand or from CSV?

            • Re: CSV loading only certain columns
              Paul Lawrence

              We would like to fetch data directly from CRM on demand but we have not found a way so was using csv export as a way of getting data in.

               

              If you have a way of fetching the data directly that would be great if not any suggestions on just bring certain fields from CSV would be great.

                • Re: CSV loading only certain columns
                  Karthikeyan S

                  I don't have idea on directly fetching from CRM..

                   

                  But from CSV, you can fetch selected column..

                   

                  Go to file --> Edit Script --> Click On "Table Files" and select your csv file --> Next --> Finish.

                   

                  Now the script will pasted on Edit Script like below

                   

                  LOAD [Doc Date],

                       [Customer ID],

                       [Plant ID],

                       Brand,

                       [Employee ID],

                       [Collection Value],

                       [Entry Date],

                       [Collection Type]

                  FROM

                  [..\Desktop\RPC_COLLTXN_20130619_002.CSV]

                  (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

                   

                   

                  Here you can remove any column. If you don't want entry date.. you can change like below..

                   

                  LOAD [Doc Date],

                       [Customer ID],

                       [Plant ID],

                       Brand,

                       [Employee ID],

                       [Collection Value],

                       [Collection Type]

                  FROM

                  [..\Desktop\RPC_COLLTXN_20130619_002.CSV]

                  (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

                   

                   

                  now save the file and reload thats all...