Data Understanding

[AmanBohra1]

Hi Folks,

I've a scenario where i'll need to handle more than 1000's fields with more than 50000 line items.

For example all the fields and field values in table is defined as below table

Field	ABC	DEF	PQR	----------	XYZ
Field Value
1	AB	12	a12	----------	KJ
2	BC	34	b098	----------	0
3	DE	8	C12z	----------	8
|	|	|	|	----------	|
|	|	|	|	----------	|
10000	IF	78	K42	----------	T5T

How can I achieve the below output

Field	Field Value
ABC	AB,BC,DE,-----------------,IF
DEF	12,34,8,-----------------,78
PQR	a12,b098,C12z,-----------------,K42
|	|
XYZ	KJ,0,8,-----------------,T5T

Request for your support.

Thanks in advance..!!

Regards,

Aman

[MayilVahanan]

Hi @AmanBohra1 

Try like below

T1:
CrossTable(F1, FV)
LOAD RowNo() as R1, * INLINE [
ABC, DEF, PQR, ----------, XYZ
AB, 12, a12, ----------, KJ
BC, 34, b098, ----------, 0
DE, 8, C12z, ----------, 8
IF, 78, K42, ----------, T5T
];

LOAD F1, Concat(FV, ',') as FV Resident T1 Group by F1;

DROP Table T1;

O/P: