Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

CSV loading only certain columns

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

1 Solution

Accepted Solutions
Not applicable

Re: CSV loading only certain columns

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

3 Replies
Not applicable

Re: CSV loading only certain columns

Hi,

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

Not applicable

Re: CSV loading only certain columns

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.

Not applicable

Re: CSV loading only certain columns

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

Community Browser