🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

Cross table

JabazanJabazan Member Posts: 2 Newbie
Hello, I am trying to get the information of several Excel files in a folder. 
Each file has the following format:

 Date store1 store2 store3
dd/mm/yyyy  $ #.00(sales)  etc

I would like to crosstable this formato to obtain this one:

Date store_id Sales
dd/mm/yy store1 $ xxxx

I will appreciate your guide to get an answer.
Best regards 

Best Answer

Answers

Sign In or Register to comment.