merging multiple fields in one field

[Anonymous]

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);

[surendraj]

Edit:

Sorry I missed operators.

GreenCard &'  - '  & VoterID &'  - ' & DrivingLicense as address proof

[ramasaisaksoft]

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);

[sasikanth]

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!!!