Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
concat(mergefield, ',')
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
;
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;