Conditionally Replace Multiple Columns

[Nick Burns]

TEST	SAT	SUN	MON	TUE	WED	THU	FRI
DEL	0	0	0	0	0	0	0
R	0	0	8	8	8	8	8

Using the table above, I'd like to null out the values of SAT-FRI when the value in TEST = DEL.
Not sure if this would be a Table.ReplaceValue, but thinking this is a TransformColumns issue.

 

[Bob Phillips]

Why not keep it simple? Unpivot those columns, add a column with null for that condition, delete the original Value and rename the new column, then pivot back.

 

[Nick Burns]

I get what your saying, but call it my anxiety, but if my recordset has 2,000+ rows, doesn't pivoting the columns now make the dataset 14,000+ rows to now check causing a lot of processing time?
Or is the processing still the same since I'm doing the replacement 7 times over the course of 2,000 records?