topic Re: CSV loading only certain columns in QlikView

CSV loading only certain columns

Wed, 19 Jun 2013 11:43:03 GMT

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

Wed, 19 Jun 2013 11:44:51 GMT

Hi,

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

Re: CSV loading only certain columns

Wed, 19 Jun 2013 11:47:50 GMT

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

Wed, 19 Jun 2013 11:59:32 GMT

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...