Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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