Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vinodh_qlikview
New Contributor III

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
Contributor III

Re: same name generation in columan

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

));

5 Replies
bgerchikov
Contributor III

Re: same name generation in columan

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

Re: same name generation in columan

Load the file as 2 differnt tables.

See Sample

vinodh_qlikview
New Contributor III

Re: same name generation in columan

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

bgerchikov
Contributor III

Re: same name generation in columan

Here it is attached.

vinodh_qlikview
New Contributor III

Re: same name generation in columan

thanks a lot