i have a XL sheet and columns name called id,month but month containing sales amount like 1000? but i want jan,feb...like under month? how?

[#1]

i have a XL sheet and columns name called id,month but month containing sales amount like 1000? but i want jan,feb...like under month? how?

pls tell me

[#2]

Hi,

Can you share an example of your data, please? Because Im not sure understand and I don't want give you a wrong answer.

Regards.

[#3]

i have no sample app  sorry for that   and  my questions is

in XL file i have 12 sheets  and names like above i have mentioned  and all 12 sheets fields are same only sheet names or different

my requirement is i want load all 12 sheets at a time in single load statement?

[gmoraleswit · Accepted solution]

Check this: Load Multiple excel sheets using For loop

[#5]

Hi,

Ok you can try a "for each next" load, something like this:

FOR Each vMonth in 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'

     LOAD

          Field1,

          Field2,

          FieldN

     From [..\source\XLFile.xlsx]

     (biff, embedded labels, table is $(vMonth)$);

NEXT vMonth

Regards.

[#6]

pls  share sample qvw  or  script in clear manner i am getting confusion over there

[#7]

Sure,

Here you are.

Regards.