topic Re: Join after concaternate in QlikView

Join after concaternate

didierodayo — Thu, 20 Apr 2017 05:03:35 GMT

Hi all ,

am trying to find the best way to achieve the scenario below. I have attached the qvw file as well.

Basically I need to join Table B to Table A in the example below.

thanks

TableA:
LOAD * INLINE [CATEGORY,DATE
A,MONDAY
B,TUESDAY
C,WEDNESDAY
D,THURSDAY
E,FRIDAY
F,SATURDAY
];

TableB:
LOAD DATE,'M' AS [DATE CODE] Resident TableA WHERE DATE='MONDAY';

Concatenate (TableB)
LOAD DATE,'F' AS [DATE CODE] Resident TableA WHERE DATE='FRIDAY';

Re: Join after concaternate

jonathandienst — Thu, 20 Apr 2017 05:14:12 GMT

I am not sure what you are tryiing to do. You don't even need a join in your scenario. You can leave the data in two separate tables and rely on QV's association. Or you can load the DATE CODE in the Inline script, like

TableA:

LOAD *,

If(DATE = 'MONDAY', 'M',

If(DATE = 'FRIDAY', 'F')) as [DATE CODE]

INLINE

[

CATEGORY,DATE

A,MONDAY

B,TUESDAY

C,WEDNESDAY

D,THURSDAY

E,FRIDAY

F,SATURDAY

];

Re: Join after concaternate

didierodayo — Thu, 20 Apr 2017 05:51:13 GMT

Hi Jonathan,

I have a complex model this was just an example. my requirement is that to dump table b back into table A and have only one tableA with columns CATEGORY;DATE;[DATE CODE].

Re: Join after concaternate

didierodayo — Thu, 20 Apr 2017 05:56:09 GMT

fixed