topic Re: Question about joins. in QlikView

Question about joins.

Mon, 05 Aug 2013 14:41:56 GMT

Hi Guys,

Can anyone out there help me solve this issue I have?

Please see below

LOAD * INLINE [

Name, ID

abc123Abandoned Cart_xiyudhu289192, 58973

asdasd234Abandoned Cart_xihu282392, 58975

xsasdass293tBrowers_dhu23432, 56456

];

LOAD * INLINE [

CampaignName, Cost, Date

Abandoned Cart, 3108, 41468

Browers, 827, 41468

];

Result Needed

1 Table That looks like

Name	ID	Cost	Date
abc123Abandoned Cart_xiyudhu289192	58973	3108	41468
asdasd234Abandoned Cart_xihu282392	58973	3108	41468
xsasdass293tBrowers_dhu23432	56456	827	41468

I can't seem to join the two tables where i need to do some sort of dyname string match.

Please help!

Thanks.

Re: Question about joins.

RedSky001 — Mon, 05 Aug 2013 15:22:36 GMT

See the attached file.

Re: Question about joins.

swuehl — Mon, 05 Aug 2013 15:30:36 GMT

Almost the same approach as Mark, using substringcount and creating a final table:

LOAD * INLINE [

Name, ID

abc123Abandoned Cart_xiyudhu289192, 58973

asdasd234Abandoned Cart_xihu282392, 58975

xsasdass293tBrowers_dhu23432, 56456

];

JOIN (A) LOAD * INLINE [

CampaignName, Cost, Date

Abandoned Cart, 3108, 41468

Browers, 827, 41468

];

RESULT:

LOAD Name,ID,Cost,Date

RESIDENT A

where substringcount(Name,CampaignName);

drop table A;

Re: Question about joins.

Mon, 05 Aug 2013 15:47:45 GMT

I understand that if the 2 tables I create and wish to join works, but if the 2 tables are huge, this may cause a problem. Is there another way you guys can suggest or is this the best possible way? Thanks.

Re: Question about joins.

RedSky001 — Mon, 05 Aug 2013 16:00:26 GMT

Well it's good practice to use numbers for the key fields. So I've done this in my revised version (attached).

I would just give it ago and see what happes...

Re: Question about joins.

Mon, 05 Aug 2013 16:02:21 GMT

Appreciate this could you take a look at my follow up question thanks a lot.

Re: Question about joins.

Mon, 05 Aug 2013 16:06:45 GMT

This is great thanks Mark!