topic Re: Help with Data loading from Excel in QlikView

Help with Data loading from Excel

qlikuser222 — Sat, 16 Nov 2024 01:22:42 GMT

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

Re: Help with Data loading from Excel

neelamsaroha157 — Fri, 31 Jan 2020 16:25:12 GMT

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, '-'))
));

Re: Help with Data loading from Excel

Brett_Bleess — Mon, 24 Feb 2020 22:13:31 GMT

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_Transform.htm

Regards,
Brett