topic Re: Query in QlikView

Query

Mon, 15 Dec 2014 09:15:41 GMT

Hello,

When i run the below code .

load * inline [
code,Name
1,A
1,B
2,C
3,D
4,E
5,F
];

i want to get the code 1 and the Name in the same line

1 A / B

2 C

3 D

4 E

5 F

anbu1984 — Mon, 15 Dec 2014 09:18:04 GMT

Load code,Concat(Name,' / ') As Name Group by code;

load * inline [
code,Name
1,A
1,B
2,C
3,D
4,E
5,F
];

mato32188 — Mon, 15 Dec 2014 09:20:33 GMT

Hi,

tmp:

load * inline [

code,Name

1,A

1,B

2,C

3,D

4,E

5,F

];

LOAD code, Concat(Name, ' / ') as New

Resident tmp

Group by code;

DROP Table tmp;

its_anandrjs — Mon, 15 Dec 2014 09:21:59 GMT

Hi,

Create another table like this way

load * inline [

code,Name

1,A

1,B

2,C

3,D

4,E

5,F

];

Load code,Concat(Name,' / ') As NewName Resident A Group by code;

Regards

Anand