Hi There,
Thanks in advance for taking the time to read this / help me solve the problem.
I have 8 columns, with around 100,000 rows of different combinations. Each row will have some empty cells in certain columns. I want to design a workflow that looks at the possible combinations and autofills the empty cells when it is certain there is no other combination.
Example: Let's say the filled out data has 4 columns like this:
Phone - Apple - iPhone8 - 128gb
Phone - Apple - iPhone8 - 256gb
But the data I am working with has this:
(Blank) - (Blank) - iPhone8 - 128gb
Phone - Apple - iPhone 8 - (Blank)
(Blank) - Apple - (Blank) - (Blank)
For the first line, we can see if it an iPhone 8 128gb, so we know for a fact that is an Apple product and is a phone, so it should autofill in Phone & Apple into the first 2 columns
For the second line we can see that we only have the memory size missing, however there are two possible combinations for this so it isn't certain, so the workflow should leave this blank
For the 3rd one, we only have "apple", we don't know if this is a tablet, or the type of apple product, or the size, so it leaves it all blank,
Hope this makes sense, please let me know what works best. I'll check back tonight and of course mark solution / like responses.
