Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi
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
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;
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.
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;
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 |
John,
Why not use applymap() for same??
Check this?
Qlik Design Blog : Don't join - use Applymap in... | Qlik Community
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