Data Understanding

AmanBohra1 — Mon, 05 Jul 2021 07:38:34 GMT

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

Re: Data Understanding

MayilVahanan — Mon, 05 Jul 2021 08:23:01 GMT

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:

topic Re: Data Understanding in App Development

Data Understanding

Re: Data Understanding