Hey everyone,
Urgent help on this please,
I have this excel where i have some columns, what i need is that i want to get this data into my data model with a condition that where there is Vendor ID absent, the records should be picked up by Vendor Name and where Vendor Id is present it should pick the reocrds with Vendor Id.
My fields in data model for Vendor Id is Global Vendor and for Vendor Name is Suppliers.
Please help and let me know how can i link this data on the scenario i mentioned.
Thanks.
