Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

same name generation in columan

HI ,

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

this is the problem;

source data:

document idbroker nameserial nocreated on
001chandu116-9-2012
001
216-9-2012
001
318-9-2012
002vinodh12/4/2012
002
25/4/2012
002
26/4/2012
002
47/4/2012

what i need is Output should be like this in qlikview

document idbroker nameserial nocreated on
001chandu116-9-2012
001chandu216-9-2012
001chandu318-9-2012
002vinodh12/4/2012
002vinodh25/4/2012
002vinodh26/4/2012
002vinodh47/4/2012

if any one know s pls let me know

1 Solution

Accepted Solutions
bgerchikov
Partner - Creator III
Partner - Creator III

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))

));

View solution in original post

5 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

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))

));

Not applicable

Load the file as 2 differnt tables.

See Sample

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

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

bgerchikov
Partner - Creator III
Partner - Creator III

Here it is attached.

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

thanks a lot