topic Re: Merging the next value value in single column using seperator in QlikView

Merging the next value value in single column using seperator

Wed, 30 Jul 2014 11:35:05 GMT

I have a requirement , where i have to merge the next value into the same row with seperator

Please find the attached file.

The LEI ID column has to given in a single column with , as seperator.

Re: Merging the next value value in single column using seperator

michael_maeuser — Wed, 30 Jul 2014 11:37:35 GMT

concat(mergefield, ',')

Re: Merging the next value value in single column using seperator

maxgro — Wed, 30 Jul 2014 11:59:46 GMT

LOAD

AGENTID, AgentName, AGENTCOUNTRYNM, MARKET_SECTOR_DESC,

concat(LEIID, ', ') as LEID,

ULTPRNTAGENTID, AGENTLEGALNAME, RatedFlag, VERIFIEDBY, VERIFIEDFLAG, IS_RATED, ULT_PARENT

FROM sampl1.xls (biff, embedded labels, table is Sheet1$)

where RecNo()<=2

Group by

AGENTID, AgentName, AGENTCOUNTRYNM, MARKET_SECTOR_DESC, ULTPRNTAGENTID,

AGENTLEGALNAME, RatedFlag, VERIFIEDBY, VERIFIEDFLAG, IS_RATED, ULT_PARENT

;

Re: Merging the next value value in single column using seperator

its_anandrjs — Wed, 30 Jul 2014 12:10:33 GMT

Or you can load your table with group by statement and use Concat function for making single record with Concat(LEIID,',') as LEIID

Ex:-

LOAD

AGENTID,

AgentName,

AGENTCOUNTRYNM,

MARKET_SECTOR_DESC,

Concat(LEIID,',') as LEIID,

ULTPRNTAGENTID,

AGENTLEGALNAME,

RatedFlag,

VERIFIEDBY,

VERIFIEDFLAG,

IS_RATED,

ULT_PARENT

FROM

sampl1.xls

(biff, embedded labels, table is Sheet1$)

Group By AGENTID,

AgentName,

AGENTCOUNTRYNM,

MARKET_SECTOR_DESC,

ULTPRNTAGENTID,

AGENTLEGALNAME,

RatedFlag,

VERIFIEDBY,

VERIFIEDFLAG,

IS_RATED,

ULT_PARENT;