topic Two table in one sheet (excel file) in QlikView

Two table in one sheet (excel file)

Wed, 21 Mar 2012 03:58:00 GMT

Hi guys,

Please help me this, I have an excel, in one sheet it has two different table... (for clearer info, see attached file)

I want fields A, B, C , D be the first table

And fields E, F, G be the second table

------------------------------------------------------------------

Is it possible to set that in rows#20 is the start of new table...

KINDLY CHECK THE ATTACHED FILE... Would it be possible to do this in script or transform the excel file via qlikview wizard?

Best Regards,

Bill

Two table in one sheet (excel file)

Sokkorn — Wed, 21 Mar 2012 04:06:59 GMT

Hi Bill,

I think it is not posible to get this done. Simple way just cut the seconde table (E F G) to a new sheet and do reload. By the way let check for another reply for your requirement.

Regards,

Sokkorn

Re: Two table in one sheet (excel file)

Wed, 21 Mar 2012 18:09:02 GMT

Try with this example using excel wizard (sorry, my version is in spanish 😞

In script I used subfield to avoid data like: 23123.000000

Hope this help

Two table in one sheet (excel file)

Thu, 22 Mar 2012 00:38:52 GMT

Thanks.