same name generation in columan

[Qlik__Vinodh]

HI ,

I have one problem to do in qlikview .if any one knows pls help me.

this is the problem;

source data:

document id	broker name	serial no	created on
001	chandu	1	16-9-2012
001		2	16-9-2012
001		3	18-9-2012
002	vinodh	1	2/4/2012
002		2	5/4/2012
002		2	6/4/2012
002		4	7/4/2012

what i need is Output should be like this in qlikview

document id	broker name	serial no	created on
001	chandu	1	16-9-2012
001	chandu	2	16-9-2012
001	chandu	3	18-9-2012
002	vinodh	1	2/4/2012
002	vinodh	2	5/4/2012
002	vinodh	2	6/4/2012
002	vinodh	4	7/4/2012

if any one know s pls let me know

[bgerchikov · Accepted solution]

Vinodh,

You need to use Transformation step as follows:

Directory

;

LOAD [document id],

     [broker name],

     [serial no],

     [created on]

FROM

[..\..\..\..\..\..\..\Documents\QlikView\Test\script.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Replace(2, top, StrCnd(null))

));

[#3]

Load the file as 2 differnt tables.

See Sample

[Qlik__Vinodh]

Thank u very much .....it is working good

[bgerchikov]

Here it is attached.

[Qlik__Vinodh]

thanks a lot