Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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...

View solution in original post

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

View solution in original post