Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a cross table like this i need to bring green card ,voter ID,driving License in one single field as address proof ,how can i get this
Cross Table (Document, Status)
LOAD EmployeeID,
TaxIDStatus as TaxID,
GreenCardIDStatus as GreenCard,
VoterIDStatus as VoterID,
DrivingLicenseStatus as DrivingLicense,
AadharIDStatus as AadharID,
PassportStatus as Passport
FROM
$(QVD)EXT_EmployeeInfo.qvd
(qvd);
Edit:
Sorry I missed operators.
GreenCard &' - ' & VoterID &' - ' & DrivingLicense as address proof
Cross Table (Document, Status)
LOAD EmployeeID,
TaxIDStatus as TaxID,
GreenCardIDStatus &'-' & VoterIDStatus & ' _ '& DrivingLicenseStatus as Address Proof,
AadharIDStatus as AadharID,
PassportStatus as Passport
FROM
$(QVD)EXT_EmployeeInfo.qvd
(qvd);
HI ,
Just change the order while loading table like below
Cross Table (AddressProof ,Status,4)
TAB:
LOAD
EmployeeID,
TaxIDStatus as TaxID,
AadharIDStatus as AadharID,
PassportStatus as Passport,
GreenCardIDStatus as GreenCard,
VoterIDStatus as VoterID,
DrivingLicenseStatus as DrivingLicense,
FROM
$(QVD)EXT_EmployeeInfo.qvd
(qvd);
Not sure weather you want to get it in a single Line/Field.
Cheers!!!