Loading data in script

[#1]

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

[sujeetsingh]

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

[MayilVahanan]

Hi

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.

[#4]

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

[#5]

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

[Anonymous]

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