Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to write a script for this sort of data. how it would be possible?
As this is just a dummy data which i have on my excel sheet.
I have multiple sheets all containting the same number of fields but with different dates.
For the month of JAN | Total | ||||
---|---|---|---|---|---|
Shift | A | B | C | ||
Calls | 14 | 16 | 12 | 42 | |
Follow-up | Later | 10 | 6 | 10 | 26 |
Not Interested | 4 | 10 | 2 | 16 | |
[Day:Tuesday 01/01/2013] |
I wrote up this simple script :
LOAD Shift,
Calls,
[Follow-up],
[Day:TUSEDAY 01/01/2013] as Day
FROM
(ooxml, embedded labels, header is 1 lines, table is [1 JAN], filters(
Transpose(),
));
But Follow-Up fields contain two Sub-fields (Later,Not interested) and kindly help me with the date aswell.
Please help me in creating the correct script.
Thanks..
See V3 attached
Seems i got confussed plz provide a sample.
Please review the attached file as i forgot to attach it earlier. i hope so it will be presenting a more clear picture now.
Thanks.
See the attached file, let me now of this helps?
Mark
(edit I've attached a version 2, this loops through the work sheets)
Many thanks Mark.
You solved my problem to some extent, but still i am unable to lookup the 'Later' and 'Not interested' field, as if we delete the first row after transposing then these two fields will get deleted aswell.
The Follow-up field consists of two different fields "Later and Not-Interested", its more likely hierarchical.
I want to compute these two fields separately.
Seeking guidance from you.
Many thanks again.
Regards,
Hassam
See V3 attached
Thumbs Up.. !!
You solved my problem.
Many thanks again..