TABLE B consists of 2 parts: the first 3 columns and the last N
fp and lp construct first and last part per row.
fp=: [:(}:@{.,#*{:@{.)/.~ 1&{,.~{.,.2&}.-.0:
lp=: 1&{* 2&}. =/~([:~.2&}.)-.0:
;<@(fp,.lp)"1 ctbl
10 15 0.5 0.5 0 0 0 0
10 25 0.5 0 0.5 0 0 0
10 35 0.5 0 0 0.5 0 0
10 45 0.5 0 0 0 0.5 0
20 15 0.2 0.2 0 0 0 0
20 35 0.2 0 0.2 0 0 0
30 15 1 1 0 0 0 0
30 45 1 0 0 1 0 0
40 15 0.8 0.8 0 0 0 0
40 45 1.6 0 0.8 0 0.8 0
R.E. Boss
> -----Oorspronkelijk bericht-----
> Van: [EMAIL PROTECTED] [mailto:programming-
> [EMAIL PROTECTED] Namens Alex Rufon
> Verzonden: vrijdag 20 juli 2007 21:33
> Aan: Programming forum
> Onderwerp: [Jprogramming] Matrix Transform Problem
>
> Hello.
>
> This has stumped me. I just cant get my brains around this one.
>
> I have this table (TABLE A):
> TABLE A
> material_code consumption colorway1 colorway2 colorway3
colorway4
> colorwayN
> 10 0.5 15 25 35 45 0
> 20 0.2 15 35 0 0 0
> 30 1 15 0 45 0 0
> 40 0.8 15 45 0 45 0
>
> And I need to transform into this format (TABLE B):
> TABLE B
> material_code color total colorway1 colorway2 colorway3
colorway4
> colorwayN
> 10 15 0.5 0.5 0 0 0 0
> 10 25 0.5 0 0.5 0 0 0
> 10 35 0.5 0 0 0.5 0 0
> 10 45 0.5 0 0 0 0.5 0
> 20 15 0.2 0.2 0 0 0 0
> 20 35 0.2 0 0.2 0 0 0
> 30 15 1 1 0 0 0 0
> 30 45 1 0 0 1 0 0
> 40 15 0.8 0.8 0 0 0 0
> 40 45 1.6 0 0.8 0 0.8 0
>
> Please note that the number of colorways may be from 1 to N. Its
> arbitrarily sized.
>
> I've also attached a capture of the excel file on the event that this
> becomes unreadable.
>
> I would really appreciate if anybody would give my problem a go. Otherwise
> ... I'll do a brute-force solution. I have an idea on how to do this but
> its going to be really ugly with a lot of branching and conditions. Oh
> well, I'm going get some sleep (been away for 20 hours).
>
> Thanks in advance to anybody who give this a go. I appreciate any help.
>
> Thanks again.
>
> r/Alex
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
