split common table in two table

[theboss-123]

hello in database of ERP we have a table contain data of two column in other table

i want in qlikview to view for each column their in other column please see the enclosed file there is an example

i want to keep reception in column and make reception supplier and plan arrangement in other column

[theboss-123]

it gave just informations about type piece ='6' and transaction type='6' and not about 

[theboss-123 · Accepted solution]

THIS SCRIPT WORKED FINE

PIECE:
load
VCRNUM_0 as Piece,
VCRNUMORI_0 as Piece_Original,
IPTDAT_0,
QTYPCU_0 as Qte,
VCRTYP_0 as PIECE_TYPE,
TRSTYP_0 as Id_Dim1,
LANNUM_0 as LANNUM1,
LANMES_0 as pieces,
LOC_0,
BPRNUM_0 as FRS,
ITMREF_0 As Ref,
ITMDES1_0 as Designation,
STOFCY_0 as Site,

Date(IPTDAT_0) As Date,
        Year(IPTDAT_0) As Year,
        Month(IPTDAT_0) As Month,
        Day(IPTDAT_0) As Day,
        Week(IPTDAT_0) As Week,
        'Q' & Ceil(Month(IPTDAT_0)/3) As Quarter,
        WeekYear(IPTDAT_0) & Num(Week(IPTDAT_0), '00') As YearWeek,
        Year(IPTDAT_0) & '-Q' & Ceil(Month(IPTDAT_0)/3) As YearQuarter,
        Date(MonthStart(IPTDAT_0), 'YYYY-MM') As YearMonth,
        -Year2Date(IPTDAT_0) As YTD_Flag,
        -Year2Date(IPTDAT_0, -1) As LYTD_Flag;

SQL SELECT *
FROM sagex3lab.dbo."JOURNAL STOCK MENU";
//-------- End Multiple Select Statements ------

Transaction:
load
TRSTYP_0 as Id_Dim1,
LANNUM_0 as LANNUM2,
LANMES_0 as transaction;
SQL SELECT *
FROM sagex3lab.dbo."JOURNAL STOCK MENU LOCAL V2";

[Anil_Babu_Samineni · Accepted solution]

Please accept solution If that is resolved, so that it will be easy for next landers.