Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with Data loading from Excel

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

 

Labels (2)
1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

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

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

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
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.