Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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?
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?
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
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?
How can I create a mapping table which assigns a trading co to every number