Merging the next value value in single column using seperator

[#1]

Hi

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.

[michael_maeuser]

concat(mergefield, ',')

[maxgro]

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

;

[its_anandrjs]

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;