topic Re: Excel Proble m in QlikView

Excel Proble m

Wed, 12 Mar 2014 10:59:19 GMT

I want to import data like below format ,first column should be displayed and remaining should be below one ,no need to rename in the script level ,how to import like ?

EXCEL :

LOAD [ ID] as MMM_ID,

'Bedford' as PLANT,

@1,

@6,

@7,

@8,

@9,

@10,

@4,

FROM

(txt, codepage is 1252, no labels, delimiter is ',', msq)

where [ ID] <>' ';

Re: Excel Proble m

MK_QSL — Wed, 12 Mar 2014 11:01:52 GMT

What exactly you want? can you be more specific please?

Re: Excel Proble m

Wed, 12 Mar 2014 11:16:32 GMT

in this script all fields come from Excel ,Bedford is not in excel ,we are added that field in script ,in the excel my first column name is ID ,I want to display id as id and remaining columns name not to be displayed

,we display like below one .

LOAD

[ ID] as MM_ID,

'Bedford' as PLANT,

@1,

@6,

@7,

@8,

@9,

@10,

@4,

FROM

(txt, codepage is 1252, no labels, delimiter is ',', msq)

where [ ID] <>' ';

Re: Excel Proble m

Wed, 12 Mar 2014 11:20:21 GMT

Not sure if I understand you correctly.

1.The script looks like first column (ID) is available and is just renamed using "as".

2. Second column (Bedford) is hard coded.

3. Rest is imported from a text file with "None" as labels.

If you want to do that , then write down the hard coded or already available fields as you want, then in script editor click on "Table files", browse to the location of your text file, select and open it and in the "labels" drop down select "None".

Click on finish. You will get a script like this.

Hope this helps!

Re: Excel Proble m

ashwanin — Wed, 12 Mar 2014 11:20:33 GMT

Hi Palla,

@1,

@6,

@7,

@8,

@9,

@10,

@4,

is plant name?

If you want to remove these then just use below scipt,

LOAD

[ ID] As MM_ID,

Bedford As PLANT

FROM

(txt, codepage is 1252, no labels, delimiter is ',', msq)

where [ ID] <>' ';

Re: Excel Proble m

MK_QSL — Wed, 12 Mar 2014 11:28:38 GMT

Go to your script and add below code after SET MonthNames= .....

SET HidePrefix='@';

Re: Excel Proble m

Wed, 12 Mar 2014 11:29:12 GMT

IN the 3 point we have labels but no need to display those one.

Re: Excel Proble m

Wed, 12 Mar 2014 11:30:36 GMT

Yes, so select "None" in the labels drop down whiel importing the file.

Re: Excel Proble m

Wed, 12 Mar 2014 11:31:50 GMT

but I want to display ID right ?

Re: Excel Proble m

Wed, 12 Mar 2014 11:33:33 GMT

Yes, if ID is already available from your script. You can add it directly giving it whatever label you want.

Re: Excel Proble m

Thu, 13 Mar 2014 13:50:10 GMT

My problem is solved ,Thanks for all

Re: Excel Proble m

Fri, 14 Mar 2014 05:47:01 GMT

Hi,

Good to know that your issue is resolved.

Can you please close this thread by making correct/helpful answers, so it is easier for others facing the similar issue to figure out the hints/answers.