Join Tables

[Vaku1606]

Hello, 

I have 2 tables:

MSKA:

LOAD MANDT,
MATNR,

ERSDA,
WERKS,
LGORT,
VBELN,
CHARG,

KALAB,

KAINS;

And another one is MSKU

MATNR,
CHARG,
ERSDA,
KUNNR,
KULAB;

I want following:

1. to merge them (to have data from 2 tables into one table)

2. to apply some data conversion to this new table. For example:

a) DATE(DATE#(ERSDA,'YYYYMMDD'),'MM/DD/YYYY') AS StartDate,

b)  Today() - DATE(DATE#(ERSDA,'YYYYMMDD'),'MM/DD/YYYY') as Age

So I am stuck with how to apply this data manipulation (Stated under a) and b)) to this new merged table.

Could you please help?

Thanks in advance and regards

[vinieme12]

refer this video on data load editor

https://www.youtube.com/watch?v=rPK-1xE6VLw

MSKA:

LOAD MANDT,
MATNR,

DATE(DATE#(ERSDA,'YYYYMMDD'),'MM/DD/YYYY') AS StartDate,

Today() - DATE(DATE#(ERSDA,'YYYYMMDD'),'MM/DD/YYYY') as Age,

WERKS,
LGORT,
VBELN,
CHARG,

KALAB

From sometable;

CONCATENATE OR JOIN (https://community.qlik.com/t5/QlikView-App-Dev/Understanding-Join-Keep-and-Concatenate/td-p/328379)

Load other table;