Query

[#1]

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

ie

1 A / B

2 C

3 D

4 E

5 F

[anbu1984 · Accepted solution]

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]

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]

Hi,

Create another table like this way

A:

load * inline [

code,Name

1,A

1,B

2,C

3,D

4,E

5,F

];

B:

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

Regards

Anand