Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
name | city | amount |
manoj | a | 200 |
manoj | a | 200 |
siva | b | 300 |
siva | a | 200 |
vinod | a | 100 |
vinod | b | 100 |
i want delete duplicate value manoj a 200 how can i do this
Even, ABC also same.
Where you want to work? In script/UI?
In script only i want to delete these duplicate values
Hi Man, What r u talking about? Can you simply load this and show the output you are getting and what you are expecting
Load * Inline [
name, | city, | amount |
manoj, | a, | 200 |
manoj, | a, | 200 |
siva, | b, | 300 |
siva, | a, | 200 |
vinod, | a, | 100 |
vinod, ABC, ABC, | b, a, a, | 100 500 500 |
];
You just simply need to load this table, qlikview will remove duplicate.
HI Manoj,
I think your perception is wrong here as Load DISTINCT definitely allows duplicate values for individual fields , it always works on the combination of all fields in the table.
It removes the duplicate combination from the table.
ex:
manoj-a-200
manoj-a-200
siva-b-300
siva-a-200
vinod-a-100
vinod-b-100
If there are any other constraints pls let us know