Data transformation - fill 3 or more columns

[#1]

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

And I really need it in that form:

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

[mdmukramali]

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]

hi try this

Load *

from path

where len(Date1)>0;

[#4]

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]

Dear ,

Kindly find the attached file.

[#6]

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.

[#7]

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

[#8]

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 }

[#9]

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.

[#10]

Hi

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