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

How to associate values of one table to columns of another

Hi,


I have two tables (one from DB & another from an excel sheet) as shown below. I need to associate values from Table 1 to the columns of Table 2. Is there a function that can handle this? Can Crosstable refrence handle this and form this assoication? Pls help. Thanks!

Table 1:

FIELD NAMEFIELD VALUEFIELD DESCRIPTION
CRED_CARD_TY1 General Purpose
CRED_CARD_TY2Private Label
CRED_CARD_TY3Business Card
CRED_CARD_TY4Corporate Card
PROD_TY5Product One

Table 2:

CRED_CARD_TYPROD_TY
35
15
25
35
15
45
45
15
15
4 Replies
shree909
Valued Contributor II

Re: How to associate values of one table to columns of another

join the  two tables on the  field name which have same records.

Not applicable

Re: How to associate values of one table to columns of another

Thanks...But you cannot in this case. The idea is to bring the Description from Table 1 to Table 2 (or any output table) corresponding to the Field Values that are itemized under Field Name column. This is just a sample set. Table 2  has a ton of columns that don't have same column names on Table 1.

Luminary
Luminary

Re: How to associate values of one table to columns of another

I understand the Table1 but I don't understand how it is related to Table2. Please can you explain in detail?

Thanks,

DV

www.QlikShare.com

Not applicable

Re: How to associate values of one table to columns of another

Hi, please check if this is what you want (see attached)

I would only advise you to be careful when using crosstable to put together fields with different formats. If all your values are only numbers or only string then it's OK.

Hope this helps.

B.

Community Browser