Help with Data loading from Excel

[qlikuser222]

Hi Everyone,

We get data from excel files in the below format

Test, Values

AAA, 1

-      , 2

-      , 3

BBB, 1

-      , 2

-      , 3

from excel

I need to load them in Qlik so the output should be like below

Test, Values

AAA, 1

AAA   , 2

AAA   , 3

BBB, 1

BBB    , 2

BBB     , 3

Can any please help me to achieve above results with Qlik scripting?

Thanks

[neelamsaroha157 · Accepted solution]

When you load your data from excel, you can enable transformation and then use Fill tab to fill the values.

Here is how it should look like with your sample data - 

Directory;
LOAD Test,
Values
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1, filters(
Replace(1, top, StrCnd(equal, '-'))
));

[Brett_Bleess]

Did the poster's response get you what you needed to get things working as desired?  If so, do not forget to return to your thread and on their post, use the Accept as Solution button to give them credit for the help and let other Members know that worked.  If you did something different, please consider posting that and then mark it using the button and if you are still working on things, please leave an update with what you still need.

Here is a Help link related to what the poster was discussing: 

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/File_Wizard_Tra...

Regards,
Brett