topic Re: join in load command in QlikView

join in load command

Wed, 20 Jul 2011 02:31:08 GMT

Hi,

I need to create the table below using the load in a table resident. please help me.

tab 1

| a | b | c |

| 1 | 201101 | 201101 |

| 5 | 201101 | 201102 |

| 4 | 201102 | 201102 |

tab2

| d |

| 201101 |

| 201102 |

| 201103 |

I need...

result

tab c

| e | sum |

| 201101 | 1 |

| 201102 | 4 |

| 201103 | 0 |

select sum(tab1.a), tab2.d

from tab1, tab2

where tab1.b <= tab2.c or tab1.c is null

but i need in the resident table

nagaiank — Wed, 20 Jul 2011 05:30:40 GMT

The following script works for me to get the result you want.

Tab1:

load * Inline [

a,b,c

1,201101,201101

5,201101,201102

4,201102,201102

];

Tab2:

LOAD *, d as e;

LOAD * Inline [

201101

201102

201103

];

Left Join (Tab2) LOAD b as d, c as e,a Resident Tab1;

DROP Table Tab1;

DROP Field d From Tab2;

Wed, 20 Jul 2011 16:31:55 GMT

The logic is great, thanks very much.