Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
hi try this
Load *
from path
where len(Date1)>0;
Hi Mukram,
thank you for fast reply.
Unfortunately, I can't attach an orginal source. So this is just sample data in .txt format.
Dear ,
Kindly find the attached file.
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.
I rally need to transform my data like on this picture:
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 }
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.
Hi
I did not check full final table before, will try and let u know my findings