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

[qlikmsg4u]

Hi Anil,

Is this you are looking for? !

[yadav_anil782]

yes this is usefull for me . thanks

[#4]

Hi,

please find the attached QVW file.

Hope it will be useful and serve your purpose.

[yadav_anil782]

Hello ,

i'm also giving one another condision fom string value ;

ACCOUNT

002.00.00.000.2050.01.0000.00.000
002.00.00.000.2050.01.0002.00.000
002.00.00.000.2050.01.0008.00.000
002.00.00.000.2050.02.0000.00.000
002.00.00.000.2050.02.0003.00.000
002.00.00.000.2050.02.1003.00.000
002.00.00.000.2050.03.0000.00.000
002.00.00.000.2050.03.0003.00.000
002.00.00.000.2050.03.0008.00.000
002.00.00.000.2311.06.0000.00.000
002.00.00.000.2312.00.0003.00.000
002.00.00.000.2312.07.0002.00.000

if script will find "2312 "  between this then that is project otherwise nonproject

now i'm using this script-

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

but this is not giving correct result

[MayilVahanan]

Hi

Try like this

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

[qlikmsg4u]

Please find the attached app

[yadav_anil782]

thanks , its usefull

[qlikviewwizard]

Hi Use this script:

WildMatch1:

LOAD * , if(WildMatch(ACCOUNT,'*2312*'),'project','nonproject') as project_wise;

LOAD * INLINE [

ACCOUNT

002.00.00.000.2050.01.0000.00.000

002.00.00.000.2050.01.0002.00.000

002.00.00.000.2050.01.0008.00.000

002.00.00.000.2050.02.0000.00.000

002.00.00.000.2050.02.0003.00.000

002.00.00.000.2050.02.1003.00.000

002.00.00.000.2050.03.0000.00.000

002.00.00.000.2050.03.0003.00.000

002.00.00.000.2050.03.0008.00.000

002.00.00.000.2311.06.0000.00.000

002.00.00.000.2312.00.0003.00.000

002.00.00.000.2312.07.0002.00.000

];

[#10]

Hi Try this:

    if(isnull(ACTIVITY_CODE),'NO_PROJECT','PROJECT) AS PROJECT_STATUS

Thanks

Manju'