Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
|
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.
@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.