remove duplicate 1 value only in load script

[KirstenKa]

My loadscript looks like this and I would like to remove duplicates for Trading Co only, adding distinct next to load doesn’t work. Don’t know how to remove duplicates for the specific value Trading Co only, how to integrate this in the load script. See also attachment

[KirstenKa]

Thanks I will try this later and let you know. Is "Item" in  my script just a random value, or is "Item" part of the script which I should include?

[KirstenKa]

Thanks will try this later. Do you mean I need to remove all the values I upload in this script? -> I need those values in my data

[tealowk]

Yes, it means to remove all the other lines from this specific load statement in the script.

Load distinct loads unique records only, so if you have the same Trading Co with two different quantities, it is loaded twice.

If you need the other values afterwards in your visualisation, you could create a mapping table which assigns a Trading Co to every item number. 

But maybe you don’t need to remove the duplicates at all? 

[KirstenKa]

Thanks I will try when I start working on it again. Is "Item" part of the script or just a random value from my data?

[KirstenKa]

Thanks I will try when I start working on it. Do you mean I need to remove the other data values in my data file? Because I do need these values as well

[KirstenKa]

Thanks @MarcoWedel , the script doesn't take it as soon as I close the bracket from [Trading co]  And I still need to have my Trading Co value in there -> "where not exists" does that remove the complete column Trading Co?

[KirstenKa]

Thank @tealowk 

It doesn't take it when I add the datasource 

[KirstenKa]

How can I create a mapping table  which assigns a trading co to every number