topic Re: merging multiple fields in one field in QlikView

merging multiple fields in one field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: merging multiple fields in one field

surendraj — Fri, 24 Feb 2017 09:55:00 GMT

Edit:

Sorry I missed operators.

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

Re: merging multiple fields in one field

ramasaisaksoft — Fri, 24 Feb 2017 10:07:37 GMT

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

Re: merging multiple fields in one field

sasikanth — Fri, 24 Feb 2017 10:53:51 GMT

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