Wed Aug 17, 2022 11:17 am
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl ( This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.

Data Transform Question

Post questions or comments on how best to manage your big data problem

Wed Feb 13, 2013 2:13 pm Change Time Zone

Hello there,

I am still learning the ECL, and currently I have the pre-exist data format as A(string),B(string),C(numeric value),D(numeric value).

I want to build a matrix having row as index of A, column as index of B, (C,D) are the cell value in the matrix.

Could somebody tell me how could I do that in ECL?

I can get the number of A and B, but I do not know how to convert from a table toward the matrix?

Posts: 36
Joined: Tue Jan 22, 2013 7:19 am

Sat Feb 16, 2013 4:40 pm Change Time Zone

The TABLE command may be what you are looking for, but I may be misunderstanding your question. If so, you may want to post some example input and desired output values.


Community Advisory Board Member
Community Advisory Board Member
Posts: 571
Joined: Tue Oct 18, 2011 4:45 pm

Return to Managing Big Data

Who is online

Users browsing this forum: No registered users and 1 guest