topic Re: How to Achieve this in QlikView

How to Achieve this

alvinford — Tue, 30 Sep 2014 15:12:00 GMT

Hi ,

I have the data in the following format.

I have to convert the data into the following format.

Request your help to achieve this.

Please find the attached Excel

Regards,

Alvin

jer_2011 — Tue, 30 Sep 2014 16:36:48 GMT

Hola,

Espero te sirva este ejmplo:

//script

Tabla1:

Load Data,

if(isnull(Peek('Data1'))=-1,Data,if(num(Data)>0,Peek('Data1'),if(len(Data)=2,Peek('Data1'),Data))) as Data1,

if( num(Data)>0, Data, null()) as Code

FROM

LB01_20140930_223437.xls

(biff, embedded labels, table is Sheet1$);

NoConcatenate

tabla_final:

Load Data1 as Data,

Code

Resident Tabla1

where Code <> null();

DROP Table Tabla1;

// te quedara de la siguiente forma

saludos espero te sirva.

alvinford — Wed, 01 Oct 2014 02:15:30 GMT

Dear Velasco,

Thank you for your reply.

Have a great day.

Regards,

Alvin.