Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
Hi,
Do you wants to fetch data directly from Oracle on demand or from CSV?
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.
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...