topic Re: Concatenation and Cross Table in QlikView

Concatenation and Cross Table

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

I have script as below...Is this correct was of concatenating ? as Description is not merging together ..

Expense:

Load

ID,

Description,

Expense,

Rent,

Non-Rent

from Table a;

OtherExpTmp:

crossTable(Description, Cost, 1)

LOAD

ID

Insurance,

Rent,

Depreciation,

Other

FROM Table B;

Concatenate Expense:

Load

ID,

Description,

Cost,

if(wildmatch(Description,'*Rent*'),'Rent','Non-Rent') as [Rent-NonRent],

if(wildmatch(Description,'*Rent*'),Description) as [Rent]

Resident OtherExpTmp;

drop table OtherExpTmp;

Re: Concatenation and Cross Table

swuehl — Mon, 27 Mar 2017 21:12:07 GMT

Try

Concatenate (Expense)

Load

ID,

Description,

Cost,

if(wildmatch(Description,'*Rent*'),'Rent','Non-Rent') as [Rent-NonRent],

if(wildmatch(Description,'*Rent*'),Description) as [Rent]

Resident OtherExpTmp;

drop table OtherExpTmp;