Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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: