join issue &need to be add new column

[yadav_anil782]

Dear qlikview expert,

i' facing  littel problem in join two tables  plz help to resolve this issue

i have share two table in attached excel -

1- XXM3M_PO_INFO_VW

2- xxm3m_payment_terms( commen fiel "terms_id " is repeating )

commen field is Terms_id(commen field terms_id  is not repeating)

problem 1- i need to add one new field in XXM3M_PO_INFO_VW  table

condision- if  column name "ACTIVITY_CODE" is blank then it should be return value "non_project" or if ACTIVITY_CODE has value then it should be return value "project"

problem2- now afer join both table i need only data against "XXM3M_PO_INFO_VW" table, if there is only two term_id in this table  then i need only those two  terms_id againsed data from both table

[jagan]

Hi,

Try like this

LOAD

*,

if(ACCOUNT LIKE  '*2312*','project','nonproject') as project_wise

FROM DataSource

Hope this helps you.

Regards,

Jagan.