topic Link MultiFields in QlikView https://community.qlik.com/t5/QlikView/Link-MultiFields/m-p/231151#M715644 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am working on credit card system where i have two main tables. First table (CardMast) contain credit card portfolio and demographics and second table (Card_TXN) contains credit card transaction.</P><P>I have join these tables with credit card no (field name CARD_NO) but i am facing issues with card transaction table. In Card TXN table the card no field is a conditional field which contain BASE_SEGMENT_NUMBER as well in some transaction. means card_no field of card_TXN is having 2 fields i.e. card_no &amp; BASE_SEGMENT_NUMBER. Can anyone guide me that what i have to do with this data and how can i link these (BASE_SEGMENT_NUMBER) with CARDMAST?</P><P>CURRENTLY, the transaction having BASE_SEGMENT_NUMBER are showing under NULL demographical data or portfolio data.. i.e. I couldn't figure out that these transactions are for which product, customer, bucket.. etc.</P><P>Regards,<BR />SHUMAIL HUSSAIN</P></BODY></HTML> Wed, 04 Nov 2009 17:07:21 GMT shumailh 2009-11-04T17:07:21Z Link MultiFields https://community.qlik.com/t5/QlikView/Link-MultiFields/m-p/231151#M715644 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am working on credit card system where i have two main tables. First table (CardMast) contain credit card portfolio and demographics and second table (Card_TXN) contains credit card transaction.</P><P>I have join these tables with credit card no (field name CARD_NO) but i am facing issues with card transaction table. In Card TXN table the card no field is a conditional field which contain BASE_SEGMENT_NUMBER as well in some transaction. means card_no field of card_TXN is having 2 fields i.e. card_no &amp; BASE_SEGMENT_NUMBER. Can anyone guide me that what i have to do with this data and how can i link these (BASE_SEGMENT_NUMBER) with CARDMAST?</P><P>CURRENTLY, the transaction having BASE_SEGMENT_NUMBER are showing under NULL demographical data or portfolio data.. i.e. I couldn't figure out that these transactions are for which product, customer, bucket.. etc.</P><P>Regards,<BR />SHUMAIL HUSSAIN</P></BODY></HTML> Wed, 04 Nov 2009 17:07:21 GMT https://community.qlik.com/t5/QlikView/Link-MultiFields/m-p/231151#M715644 shumailh 2009-11-04T17:07:21Z Link MultiFields https://community.qlik.com/t5/QlikView/Link-MultiFields/m-p/231152#M715645 <HTML><HEAD></HEAD><BODY><P>Thanks, I just resolve this issue by myself... that was basically the issue of massaging &amp; cleansing the data.</P><P>Regards,<BR />Shumail Hussain</P></BODY></HTML> Thu, 05 Nov 2009 19:25:42 GMT https://community.qlik.com/t5/QlikView/Link-MultiFields/m-p/231152#M715645 shumailh 2009-11-05T19:25:42Z