Discussion Board for collaboration on QlikView Scripting.
In the script, I want to replace Amount with 0 if any of its types are B, else leave it alone, resulting in:
How can I do this?
Try like this
Load * Inline
Load ID,Concat(Type,',') as Type Resident DimTable Group by ID;
Load ID,Type, If(WildMatch(Type,'*B*'), 0, Amount) as Amount Resident FactTable;
DROP Tables DimTable, FactTable;