Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Two table in one sheet (excel file)

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Two table in one sheet (excel file)

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

Wizard.gif

In script I used subfield to avoid data like: 23123.000000

Hope this help

3 Replies
Sokkorn
Not applicable

Two table in one sheet (excel file)

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

Not applicable

Re: Two table in one sheet (excel file)

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

Wizard.gif

In script I used subfield to avoid data like: 23123.000000

Hope this help

Not applicable

Two table in one sheet (excel file)

Thanks.