Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
possible to share some sample data (exact format) ??
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