Hi,
Bit of a weird one to ask, so bear with me :)
We have a data set that is imported and work flowed. At the end of the workflow the data looks like this:
Record | Supplier | Purchaser | PO Number | Location |
1 | A | NULL | 20714 | BBBB |
2 | A | Bob S | 21677 | BBBB |
3 | B | NULL | 21655 | EEEE |
4 | B | NULL | 21655 | EEEE |
5 | B | Mary Y | 21341 | EEEE |
6 | B | NULL | 21342 | EEEE |
7 | A | NULL | 21678 | BBBB |
We can see from the table above there are NULLs in Purchaser. Using columns Supplier and Location we can see that record 2 should be Bob, and records 3, 4, and 6 should belong to Mary.
Is it possible / how does one then use the current data set to fill in the NULLs? I have tried filtering the dataset, then joining (vlookup) on the original data set but this does not work.
Any suggestions?
Thanks.
Solved! Go to Solution.
@Baz123
We can seperate the records with Purchaser as Null then join with those are not withe key of 'Supplier' and "Location".
Hi @flying008 ,
Can you post the workflow so I can see the config?
It looks to be a simple fix.
Thanks.
Hi, @Baz123
If your supplier have N purchasers in location xxx. you can Join Supplier&Location as new filed to match.
Hi @flying008
Your solution worked great. I had to tweak it slightly to work in the real data, but it sorted the issue.
:)