topic Re: join issue &need to be add new column in QlikView

join issue &need to be add new column

yadav_anil782 — Tue, 07 Jul 2015 07:18:01 GMT

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

Re: join issue &need to be add new column

qlikmsg4u — Tue, 07 Jul 2015 07:29:53 GMT

Hi Anil,

Is this you are looking for? !

Re: join issue &need to be add new column

yadav_anil782 — Wed, 08 Jul 2015 04:33:34 GMT

yes this is usefull for me . thanks

Re: join issue &need to be add new column

Wed, 08 Jul 2015 05:03:29 GMT

Hi,

please find the attached QVW file.

Hope it will be useful and serve your purpose.

Re: join issue &need to be add new column

yadav_anil782 — Thu, 09 Jul 2015 06:44:32 GMT

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

Re: join issue &need to be add new column

MayilVahanan — Thu, 09 Jul 2015 06:49:43 GMT

Try like this

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

Re: join issue &need to be add new column

qlikmsg4u — Thu, 09 Jul 2015 06:53:51 GMT

Please find the attached app

Re: join issue &need to be add new column

yadav_anil782 — Thu, 09 Jul 2015 06:56:45 GMT

thanks , its usefull

Re: join issue &need to be add new column

qlikviewwizard — Thu, 09 Jul 2015 07:16:41 GMT

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

];

Re: join issue &need to be add new column

Thu, 09 Jul 2015 07:44:48 GMT

Hi Try this:

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

Thanks

Manju'

Re: join issue &need to be add new column

jagan — Thu, 09 Jul 2015 07:59:03 GMT

Hi,

Try like this

LOAD

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

FROM DataSource

Hope this helps you.

Regards,

Jagan.