Looking for Multiple Values

[Saro_2306]

Hi All,

Consider below table,

Input:

A, B

1,Area

1,Club

2,District

3,Country

3,Street

Output:

While looking for Values 1 - Area, Club 2 - District, 3 - Country, Street as like i need multiple values as output.

Anybody can help. Thanks in Advance.

[sasikanth]

possible to share some sample data (exact format) ?? 

[JuanGerardo]

Hello,

The solution to this problem is the Concat() function. An example:

Input:
Load *
Inline [
A, B
1,Area
1,Club
2,District
3,Country
3,Street
];


Output:
Load
	A,
    Concat(B, ',')	AS ConcatenatedB
Resident Input
Group By A;

Drop Table Input;

The Output table is:

JG