Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Chandu9
Contributor
Contributor

How to map fields different tables

We have two tables,

-in first table contains customer id,2nd tables we have 4 fields 

1)zu partner num,2)ship to code 3)sold to code,4)Bill to code

First link using'zu partner id'and get account names,for the remaining unmaped unmaped accounts,use ship to code,for the remaining unmaped accounts,use sold to code,names,for the remaining unmaped  accounts,use ship to code Bill to code.

To get all the account names using above logic.

Labels (1)
1 Reply
Taoufiq_Zarra

@Chandu9  can you share a sample data and the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉