topic Re: Loading data in script in QlikView

Loading data in script

Mon, 25 Nov 2013 06:46:31 GMT

Hi All,

i have 2 datasheets first datasheet contains fields ID, Num, Name,Owner, Nov,Dec,Jan, Manager, Loc, Add, Con

Second datasheet contains Num, Name,Owner, Nov (P/D),Dec(P/D),Jan(P/D), Manager, Loc, Add, Con

These data sheets are loacated in one path and these will update on weekly basis the data should load automatically

Upto january month fileds are like Nov, Dec, Jan and then field names are like Feb, Mar, Apr

I want to load the fields with order as like ID, Num, Name, Manager, Nov, Dec, Jan from first data sheet and

load the fields with order as like Num, Name, Manager, Nov, Dec, Jan from second data sheet, here i have to remove (P/D) from Nov (P/D),Dec(P/D),Jan(P/D).

Here we have to load data without mentoning the field names.

If we load data as load ID, Num, Name, Manager, Nov, Dec, Jan from Sheet, For now it's Ok but in future Nov, Dec, Jan will change as Feb, Mar, Apr

So i have to load data without mentioning field names

I attached sample data files also, So could you please anyone look into this issue.

Thanks,

Chiru

Re: Loading data in script

sujeetsingh — Mon, 25 Nov 2013 06:55:20 GMT

hello i am confused a little bit can you please load the data in a qvw and send it to me.

Re: Loading data in script

MayilVahanan — Mon, 25 Nov 2013 07:00:10 GMT

Try like this

Sheet2:

LOAD *

FROM

Sheet2.xlsx

(ooxml, embedded labels, table is Sheet1);

RENAME Field [NOV (P/D)] to NOV;

RENAME Field [DEC (P/D)] to DEC;

RENAME Field [JAN (P/D)] to JAN; // To remove P/D from fieldname; Its must declare after load the table.

Re: Re: Loading data in script

Mon, 25 Nov 2013 07:48:25 GMT

Hi Sujeet,

Thanks for reply, i'm attached sample QVW also

Actually i have many fields in data sheet but i want to load some fields without mentioning field names.

Is there any possibility while loading the data in script

Thanks,

Chiru

Re: Re: Loading data in script

Mon, 25 Nov 2013 07:50:55 GMT

HI Ramasamy,

Already i did it but for now it will work fine but in future it will not work, Because fieldnames will change in future as Feb, Mar, Apr.

So i want to load data without mentioning field names in script.

Thanks,

Chiru

Re: Loading data in script

Anonymous — Mon, 25 Nov 2013 08:13:17 GMT

Chiranjeevi

Have looked at using a Generic Load ?

Searching this forum on Generic Load will give many hits. This one gives a sample qvw:

Generic Load

Best Regards, Bill