Data Transform Question
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?
Thanks
Bo
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?
Thanks
Bo
- buptkang
- Posts: 36
- Joined: Tue Jan 22, 2013 7:19 am
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.
Cheers,
Dan
Cheers,
Dan
- DSC
- Community Advisory Board Member
- Posts: 571
- Joined: Tue Oct 18, 2011 4:45 pm
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest