I have 3 fields: Item, Type and Value. Each item has 2 types, A and B. I would like to have 3 fields: Item, A and B so A would be Value when type is A and B would be Value when type is B. In other words I would like to get rid of Type field so I could sum Type A and B values separately easily. How would I do this, with crosstable?
LOAD * INLINE [
Item, Type, Value
1, A, 10
2, B, 11
3, A, 12
4, B, 13
Load distinct Item Resident Input;
Drop Table Input;
FOR i = NoOfTables()-1 to 0 STEP -1
//trace $(i) - '$(vTable)';
IF WildMatch('$(vTable)', 'DATA.*') THEN
LEFT JOIN ([CombinedGenericTable]) LOAD distinct * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
Regards, Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "