Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thanks.