import excel file in oracle with Merged cells

Anonymous — Fri, 23 Mar 2018 20:09:02 GMT

Hi everyone,

I would like to ask your tips how to solve this issue.

I need to import excel file in oracle db, but this excel file has merged cells,

This example that i have in my excel file:

PS: I don't know how to merge the cells here in the topic, but i sent the example attached.

Plan	Cardinality	Offer
Oferta Base- Movil Hibrido Masivo- No AVI - Antiguos	1..1	Promoción doble de navegación.
		Promoción redes sociales.
Oferta Base- Movil Pospago - Antiguos	0..1	Promoción doble de navegación.
		Promoción redes sociales.

This is the result that i expect to be loaded in oracle db:

Plan	Cardinality	Offer
Oferta Base- Movil Hibrido Masivo- No AVI - Antiguos	1..1	Promoción doble de navegación.
Oferta Base- Movil Hibrido Masivo- No AVI - Antiguos	1..1	Promoción redes sociales.
Oferta Base- Movil Pospago - Antiguos	0..1	Promoción doble de navegación.
Oferta Base- Movil Pospago - Antiguos	0..1	Promoción redes sociales.

Thanks a lot!

Re: import excel file in oracle with Merged cells

vboppudi — Fri, 23 Mar 2018 21:31:44 GMT

If you are looking for the following output, you can achieve this by using tMap variable ports.

Regards,

Anonymous — Wed, 28 Mar 2018 18:58:41 GMT

Hi Veeranjaneyulu,

Thanks a lot for your support!!!

Your solution is working fine!