I have 2 Domains 1. INTERNAL CUSTOMER 2. EXTERNAL CUSTOMER. There are many Customer data under these Domains mentioned below:
Internal Customer
External Customer
Customer 1
Customer 5
Customer 2
Customer 6
Customer 3
Customer 7
Customer 4
Customer 8
Customer 9
Customer 10
All these Sub Accounts are fetching data from different data sources. For eg Customer 1 is fetching data from TOOL1, Customer 2 fetching data from TOOL 2 and Customer 3 is fetching data from TOOL 3 etc..
Now here Customer 1(ticket ID) is ID, For Customer 2 its is Ticket_ID and for Customer 3 it is T_ID.
Now i want to create a master excel which recognizes these Sub Accounts & takes ID, Ticket_ID ,T_ID as Call_ID.
or let me know how Qlikview will understand and take data from columns of various excel and bring into a one view with master field names.
Since the coloumn names are different for different Sub Accounts without concatenating i want to consolidate everything into one MASTER FIELD. The idea is to reduce the manual efforts of renaming the fields.
