Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
MathiasT
Partner - Contributor
Partner - Contributor

Accessing first column of pivot

Hi together,

I've sorted my customer by ID/Number and Name in a pivot. How can I access or check, whether DB1 or Zahlungsmoral is referencing to the correct customer-No?

I've found no way to get the ID 1000093 from the first column. Because the first column starts at DB1.

And I need the pivot, because a lot customer have more than one customerNumber.

 

pivot.png

I hope you had this issue and could help me in this matter.

Greetings,

Mathias

Labels (1)
1 Reply
Anil_Babu_Samineni

I would suggest load two different tables with different fields from 2 DB's and then check?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful