topic Load in QlikView

Load

NavinReddy — Mon, 17 Mar 2014 16:02:10 GMT

Dear All,

I have a fieldname,inside i have many fieldnames

how can i load only 5 fieldsnames while loading excel in qlikview (fieldname=a,b,c,d,e) like that

Help me some one

Thanks in Advance

Niranjan

Re: Load

MK_QSL — Mon, 17 Mar 2014 16:04:55 GMT

can you share your sample file?

Re: Load

PrashantSangle — Mon, 17 Mar 2014 16:06:49 GMT

Hi,

You can do this at transformation step,

When you are loading table-> Next->Enable Transformation Table

Re: Load

NavinReddy — Mon, 17 Mar 2014 16:09:40 GMT

Hi Manish,

while loading excel sheet i want load only fivenames

using if condition is it possible

please help

Regards,

Niranjan

Re: Load

giakoum — Mon, 17 Mar 2014 16:13:32 GMT

if you have a field like : date,product,area,value then read this field into a variable :

FieldsToLoad:

load

FieldWithFields

from....

set vFieldsToLoad = fieldvalue('FieldWithFields', 1);

data:

load

$(vFieldsToLoad)

from......

Re: Load

NavinReddy — Mon, 17 Mar 2014 16:19:12 GMT

Hi loannis,

I have large data in that i want load only five

country=uk,us,chaina,india,japan like that

Regards,

Niranjan

Re: Load

giakoum — Mon, 17 Mar 2014 16:20:45 GMT

so something like :

load uk,us,chaina,india,japan from source or you want a field to be filtered? for example filter country by uk,us,chaina,india,japan

You need to be more detailed.

Re: Load

PrashantSangle — Mon, 17 Mar 2014 16:21:02 GMT

Hi,

You can write WHERE clause in Script

Where Country='uk' or Country='us' or Country='chaina' or Country='india' or Country='japan'

regards,

Re: Load

MK_QSL — Mon, 17 Mar 2014 16:29:39 GMT

Load

FieldName1,

FIeldName2,

Country

From TableName

Where Match(Country,'uk','us','chaina','india','japan');