August 17, 2018
I have a feeling that what i am going to ask here might not be possible at all but i am just here to give it a try in case there is someone out there with exceptional talent.
The question is, i want to add a conditional column for duplicates in my query. The code i am looking for would look a bit like the following when its done..
If(Item ID = 5127730, SKU Description = "HANDUA Keg 30l", "HANDUA 24x33cl","HANDUA Export LN 24x33cl" else if Item ID = 5127690, SKU Description = "TUXIDO Regular Export LN 24x33cl","TUXIDO Regular LN 24x33cl","TUXIDO Regular EURO 20x50cl","TUXIDO Regular Keg 30L","TUXIDO Special XLN 20x50","TUXIDO Regular EURO 20x50cl")
This means if the system founds Item ID 5127730 many times, i want it to assign the sku description for each duplicate item ID evenly so the final output would look something like the one i have attached here. Now, i know that there is just a really narrow possibility for it to work but just to try...
Thanks for the help!
July 16, 2010
What do you mean by "i want it to assign the sku description for each duplicate item ID evenly"? I don't see any pattern to the SKU description.
Please provide an Excel file with the tables you want to manipulate to get the desired outcome so we can fully understand what is required. Ideally you'll provide the data in the 'before' state and 'after' state.