Two table in one sheet (excel file)

[#1]

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

[Sokkorn]

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

[#3 · Accepted solution]

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

[#4]

Thanks.