Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Different field name that are the same

There are two .xls files one containing data about activities done with clients, and the other contains information about financials.  The accountant charges the head corporation.  The other details are done with subcompanies so they all have different names.  I need a way to take company x and y and be the same company z when it comes to billing.  I'm totally lost in this regard. 

Pls don't tell me to standardize my data.  In about six months to a year there is plan to go with a DB that I will eventually have to build.

1 Reply
MVP
MVP

Different field name that are the same

Well, you probably have somewhere a list that relates your head coporations to their subcompanies. If you don't, I think there is no way around creating one.

You then load this table to your data model, this will link your activities table to financials table.

Hope this helps,

Stefan

Community Browser