Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yadav_anil782
Creator II
Creator II

join issue &need to be add new column

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

10 Replies
qlikmsg4u
Specialist
Specialist

Hi Anil,

Is this you are looking for? !

yadav_anil782
Creator II
Creator II
Author

yes this is usefull for me . thanks

Not applicable

Hi,

please find the attached QVW file.

Hope it will be useful and serve your purpose.

yadav_anil782
Creator II
Creator II
Author

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
qlikmsg4u
Specialist
Specialist

Please find the attached app

yadav_anil782
Creator II
Creator II
Author

thanks , its usefull

qlikviewwizard
Master II
Master II

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

];

Not applicable

Hi Try this:

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

Thanks

Manju'