topic Re: Get the values from 2 different tables in QlikView

Get the values from 2 different tables

Wed, 27 Jan 2016 04:57:10 GMT

T1:

PRFID	ACID	Time stamp
100	1	11/10/2013
100	2	11/11/2013
100	3	11/12/2013
100	4	11/13/2014

T2:

ACID	Text
3	Comment

when am trying to display the latest record by using above tables got the output like below:

Output:

PRFID	ACID	Time stamp	Text
100	4	11/13/2014	-

but the expected result is:

all the values will be showm for the PRFID from two tables.

PRFID	ACID	Time stamp	Text
100	4	11/13/2014	Comment

Re: Get the values from 2 different tables

krishnacbe — Wed, 27 Jan 2016 05:51:44 GMT

Two tables are concatenated using the field ACID and a Outer join will be created.

Can you share a sample app with some more data. whether for all the ACID the text should be Comment?

Regards

Krishnapriya

Re: Get the values from 2 different tables

jonathandienst — Wed, 27 Jan 2016 05:53:10 GMT

The Text field in T2 associates with line 3 in T1.

Do you want the Text field in T2 to associate with all lines that contain the same PRFID as line 3?

Then you need to discard ACID in T2 and fetch the PRFID. Something like this when loading T2:

T2:

LOAD ACID, Text

From ....

Left Join (T2)

LOAD Distinct ACID, PRFID

Resident T1;

DROP Field ACID From T2;

Re: Get the values from 2 different tables

jagan — Wed, 27 Jan 2016 06:14:38 GMT

Hi,

When you join the tables based on ACID you won't get Text as comment for 4, because you have the comment only for ACID 4.

If you want the same text for all the rows then try like below

T1:

PRFID	ACID	Time stamp
100	1	11/10/2013
100	2	11/11/2013
100	3	11/12/2013
100	4	11/13/2014

T1:

LOAD

PRFID,

ACID,

TimeStamp

FROM DataSource1;

LEFT JOIN(T1)

LOAD

Text

FROm DataSource2;

Regards,

jagan.

Re: Get the values from 2 different tables

anat — Wed, 27 Jan 2016 06:20:47 GMT

Hi Jagan ,

as per your answer ,how join will work ?without any common column in both tables.

T1:

LOAD

PRFID,

ACID,

TimeStamp

FROM DataSource1;

LEFT JOIN(T1)

LOAD

Text

FROm DataSource2;

Re: Get the values from 2 different tables

anat — Wed, 27 Jan 2016 06:24:24 GMT

Hi cena,,

this is what your looking for output or something different?

PRFID	ACID	Time stamp	Text
100	1	11-10-13	Comment
100	2	11-11-13	Comment
100	3	11-12-13	Comment
100	4	11/13/2014	Comment

Re: Get the values from 2 different tables

Anonymous — Wed, 27 Jan 2016 06:28:18 GMT

John,

Why not use applymap() for same??

Check this?

Qlik Design Blog : Don't join - use Applymap in... | Qlik Community

quick applymap example

Re: Get the values from 2 different tables

sanketkhunte — Tue, 02 Feb 2016 06:42:59 GMT

How are you loading these two tables ? I mean ,which join / Concatenate are you using in Script ?

If you can share your script that will be helpful to solve this issue..

Many Thanks

Sanket