Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to concatenate the two cross-table.But i facing some trouble while concatenate
Table A:
CrossTable("KPI Name", "KPI Value",7)
Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(A-B)/A as "1.1.2 WDMD: Interface - Records With No HR Data Issue Fallout (%)",
(F-E)/F as "1.2.2 WDMD: Automated Data (%)",
(H-J)/H as "1.3.2 WDMD: New Hires - 1st Load Attempt Success (%)",
I/H as "1.3.4 WDMD: New Hires - Load Success Overall (%)",
L/K as "1.3.6 WDMD: New Hires - Employee Load Timeliness (%)",
(P-O)/P as "3.1.2 OTP: Interface - Records With No HR Data Issue Fallout (%)",
(P-S)/P as "3.2.1 OTP: Corrections vs Total Records (%)"
from source
Table B:
CrossTable("KPI Name", "KPI Value",8)
Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(vpbB/vpbA) as "4.1.1 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Timeliness (%)",
(vpbE-vpbF)/vpbE as "4.1.2 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Accuracy (%)",
vpbD/vpbC as "4.1.3 VPB/PFR: Interface - File Delivery: Timeliness (%)",
vpbH/vpbG as "4.1.4 VPB/PFR: Interface - File Delivery: Accuracy (%)",
(vpbG-vpbJ-vpbK-vpbL)/vpbG as "4.2.1 VPB/PFR: Corrections - Record Accuracy (%)",
vpbO/(vpbJ+vpbK+vpbL) as "4.2.2 VPB/PFR: Corrections - Loaded (%)",
(vpbM-vpbN)/vpbM as "4.2.3 VPB/PFR: Stop Payment Request Volumes (%)",
vpbP/vpbN as "4.2.4 VPB/PFR: Corrections - Stop Payments Processed (%)"
from source
----
case 1: If i keep Column qualifier both Table A & Table B is 7
Then its show some error
case 2:if i keep column qualifier table A=7 and table B=8
its concatenate well ,but its skip the line (vpbB/vpbA) as "4.1.1 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Timeliness (%)", from table B
Thanks in Adavnce
Hi Kavi,
Try like this:
Table A:
CrossTable("KPI Name", "KPI Value",7)
Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(A-B)/A as "1.1.2 WDMD: Interface - Records With No HR Data Issue Fallout (%)",
(F-E)/F as "1.2.2 WDMD: Automated Data (%)",
(H-J)/H as "1.3.2 WDMD: New Hires - 1st Load Attempt Success (%)",
I/H as "1.3.4 WDMD: New Hires - Load Success Overall (%)",
L/K as "1.3.6 WDMD: New Hires - Employee Load Timeliness (%)",
(P-O)/P as "3.1.2 OTP: Interface - Records With No HR Data Issue Fallout (%)",
(P-S)/P as "3.2.1 OTP: Corrections vs Total Records (%)"
from source
Table B:
CrossTable("KPI Name", "KPI Value",8)
Load
FiscalYear as FiscalYear1,
FiscalQuarter as FiscalQuarter1,
FiscalMonthNo as FiscalMonthNo1,
Region as Region1,
"HR Geography" as "HR Geography1",
Country as Country1,
Partner as Partner1,
(vpbB/vpbA) as "4.1.1 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Timeliness (%)",
(vpbE-vpbF)/vpbE as "4.1.2 VPB/PFR: Interface - Actual Eligible Earnings (AEE) Delivery: Accuracy (%)",
vpbD/vpbC as "4.1.3 VPB/PFR: Interface - File Delivery: Timeliness (%)",
vpbH/vpbG as "4.1.4 VPB/PFR: Interface - File Delivery: Accuracy (%)",
(vpbG-vpbJ-vpbK-vpbL)/vpbG as "4.2.1 VPB/PFR: Corrections - Record Accuracy (%)",
vpbO/(vpbJ+vpbK+vpbL) as "4.2.2 VPB/PFR: Corrections - Loaded (%)",
(vpbM-vpbN)/vpbM as "4.2.3 VPB/PFR: Stop Payment Request Volumes (%)",
vpbP/vpbN as "4.2.4 VPB/PFR: Corrections - Stop Payments Processed (%)"
from source;
Noconcatenate
Tab1:
Load *
resident Table A;
concatenate (Tab1)
Load
*
resident Table B;
Drop tables TableA,Table B;