Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data transformation - fill 3 or more columns

Hello QV Experts, I have a problem with data transformationinto expected format. My data source looks like that:

Before.JPG.jpg

And I really need it in that form:

AfterETL.JPG.jpg

I know, that I can use fill function in wizzard, but for 3 or 4 data levels? Is there possible to do it in script?

Do you have any idea, how to solve this problem?

I will be very grateful.

Ewe

10 Replies
mdmukramali
Specialist III
Specialist III

Dear,

you can use the if condition in script to load the required data.

can you share with us sample file so that we can help you,

Thanks,

Mukram.

preminqlik
Specialist II
Specialist II

hi try this

Load *

from path

where len(Date1)>0;

Not applicable
Author

Hi Mukram,

thank you for fast reply.

Unfortunately, I can't attach an orginal source. So this is just sample data in .txt format.

mdmukramali
Specialist III
Specialist III

Dear ,

Kindly find the attached file.

Not applicable
Author

Hi, well I want to have some categories after last Date column (like on last picture). My fist category is marked as violet colour etc. I want to garbage this statement but before that I want to create 3 or 4 levels of categories which are marked  above.

Not applicable
Author

I rally need to transform my data like on  this picture:

Not applicable
Author

Hi try to use below script

Directory;

LOAD PN1,

     PN2,

     PN3,

     Description,

     Language,

     ID,

     US,

     [Non-Emea],

     EMEA,

     Date1,

     Date2,

     Date3,

     Date4

FROM

[..\..\certification prep.xlsx]

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

Remove(Row, Pos(Top, 10)),

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 8)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2))

));

{try to use Garbage  property with delete marked }

Not applicable
Author

Hi Poja,

I rather would like to know, how to fill new columns with categories from Description.

Statements from violet cells are my Category1, from blue cells are Category2 etc. so I need them in my final table.

Not applicable
Author

Hi

I did not check full final table before, will try and let u know my findings