Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with this Excell extraction data

Hello,

Someone could help me with the following?

I have this Excell document: (example.xlsl)

The problem is,I have 18000 products and I would like to know the amount sold each month of the year.

I thought creating a date field, but I would have to write all the prices by hand and it's impossible.

I would like an Excell like this,or there is any way to load data into the script that allows me to achieve this?

(ExampleSolve.xlsl)

How could i resolve this?

Thanks a lot!

Paula.

1 Reply
ashfaq_haseeb
Champion III
Champion III

May be like this.

Regards

ASHFAQ