topic limiter the rows in QlikView

limiter the rows

pandiarajan — Fri, 04 Oct 2013 10:27:19 GMT

Dear Friends,

Table I

Region	RegionMail ID	Branch	BranchMailiD	Subbranch	SUBBRANCHMAILID
M1	M1@gmail.com	B1	B1@gmail.com	S1B1	S1B1@gmail.com
M1	M1@gmail.com	B1	B1@gmail.com	S2B1	S2B1@gmail.com
M1	M1@gmail.com	B1	B1@gmail.com	S3B1	S3B1@gmail.com
M1	M1@gmail.com	B2	b2@gmail.com	S1B2	S1B2@gmail.com
M1	M1@gmail.com	B2	b2@gmail.com	S2B2	S2B2@gmail.com

Table II

Region	ReginTotalID
M1	M1@gmail.com;B1@gmail.com;B2@GMAIL.COM;S1B1@gmail.com;S2B1@gmail.com;S3B1@gmail.com;S1B2@gmail.com;S2B2@gmail.com

i have data like Table I based on that i need Table II . i want to avoid the left join. anybody suggest any functions or other methods

Re: limiter the rows

Gysbert_Wassenaar — Fri, 04 Oct 2013 12:05:58 GMT

Try something like this:

LOAD Region, [RegionMail ID] & ';' & Concat([BranchMailiD],';') & ';' & concat(SUBBRANCHMAILID,';') as ReginTotalID

group by Region,[RegionMail ID] ;

LOAD * INLINE [

Region, RegionMail ID, Branch, BranchMailiD, Subbranch, SUBBRANCHMAILID

M1, M1@gmail.com, B1, B1@gmail.com, S1B1, S1B1@gmail.com

M1, M1@gmail.com, B1, B1@gmail.com, S2B1, S2B1@gmail.com

M1, M1@gmail.com, B1, B1@gmail.com, S3B1, S3B1@gmail.com

M1, M1@gmail.com, B2, b2@gmail.com, S1B2, S1B2@gmail.com

M1, M1@gmail.com, B2, b2@gmail.com, S2B2, S2B2@gmail.com

];

The inline load is just an example. Replace it with the load statement that loads your data. If you want to keep the orginal data too then don't use the preceding load but a resident load:

T1: