Load

[NavinReddy]

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

[MK_QSL]

can you share your sample file?

[PrashantSangle]

Hi,

You can do this at transformation step,

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

[NavinReddy]

Hi Manish,

while loading excel sheet i want load only fivenames

using if condition is it possible

please help

Regards,

Niranjan

[giakoum]

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

[NavinReddy]

Hi loannis,

I have large data  in that i want load only five

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

Regards,

Niranjan

[giakoum]

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.

[PrashantSangle]

Hi,

You can write WHERE clause in Script

Like

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

regards,

[MK_QSL · Accepted solution]

Load

     FieldName1,

     FIeldName2,

     Country

From TableName

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