Removing particular value from a table

[Qlik1_User1]

Hi All,

Can we remove a particular value from a table.

Requirement is if word 'Test' is coming with other values than remove 'Test' word and if word 'Test' is coming as a single value than don't remove it. Below is data and expected result set.

Dataset

Column 1	Column 2	Column 3
a, Test, b, c	Test	a, Test

Expected result set

Column 1	Column 2	Column 3
a, b, c	Test	a

Here Test keyword is removed from column 1 and 3 as its coming with other values but in column 2 its coming standalone so not removed.

Please suggest how to achive this.

[sidhiq91]

@Qlik1_User1  Please use the below mentioned code.

NoConcatenate
Temp:
Load *, recno() as Recno Inline [
Column 1, Column 2, Column 3
a,Test,a
Test,,Test
b,
c,
];

NoConcatenate
Temp1:
Load *
Resident Temp
where Recno<>'2';

Drop table Temp;

Exit Script;

Let me know if this worked.