how to make an join in these case

[Anonymous]

T	T1	T2	T3	V1	V2	V3
A				2	3	78
A	B			4	4	56
A	B	C		5	5	23
A	B	C	D	6	68	2
A	X			19	5	3
A	X	Y		16	4	54
A	X	Y	Z	27	5	23

Anybody pls help

I want these values into these format how to make that in qlikview

T	V1	V2	V3
A	2	3	78
B	4	4	56
C	5	5	23
D	6	68	2
X	19	5	3
Y	16	4	54
Z	27	5	23

[#2]

Hi ,

please use the below code

Tab:

LOAD * Inline

[

T, T1, T2, T3, V1, V2, V3

A,   ,  ,   , 2, 3, 78

A ,B, , ,4 , 4 ,56

A ,B, C, ,5, 5, 23

A, B ,C ,D ,6 ,68, 2

A ,X, , , 19, 5, 3

A ,X ,Y, ,16 ,4 ,54

A, X, Y, Z, 27, 5, 23

];

T1:

NoConcatenate

LOAD

if( Len(T3)=0 ,if( Len(T2)=0,if( len(T1)=0,if( len(T)=0,Null(),T  ),T1  ),T2 ), T3 ) as T

,V1, V2, V3

Resident Tab;

DROP Table Tab;

Regards

Yusuf

[#3]

Hi,

You can name the columns you want to read, and reorder them as you wish.

LOAD T, V1, V2, V3 ...

FROM ....

or if you have already loaded the file into a table:

TableXX:

NoCONCATENATE

LOAD T, V1, V2, V3

Resident YourTemptable

I do not see the point. Perhaps I do not understand what you want to do.

Fabrice

[Anonymous · Accepted solution]

Hi,

Try this code:

set NullInterpret ='';

TT1:

LOAD * Inline

[T, T1,    T2,    T3,    V1,    V2,    V3

A,   ,       ,   ,    2,    3,    78,

A,    B,      ,      ,    4,    4,    56,

A,    B,    C,      ,    5,    5,    23,

A,    B,    C,    D,    6,    68,    2,

A,    X,     ,     ,     19,    5,    3,

A,    X,    Y,     ,     16,    4,    54,

A,    X,    Y,    Z,    27,    5,    23

];

TT2:

LOAD

    If(IsNull(T3), If(IsNull(T2), If(IsNull(T1), If(IsNull(T), 0, T), T1), T2), T3) as T,

    V1,

    V2,

    V3

Resident

    TT1;

DROP Table TT1;   

Regards,

Harshal Gawande