Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
QlikTonic
Contributor III
Contributor III
‎2019-07-28 11:34 AM

Load and transform excel file

Hi everybody,

I please need your help

I have an excel file with

Parking Branchies
   
01.01.201850 
02.01.201835 
03.01.201812 
04.01.201855 
05.01.201847 
   
Parking Allumettes
   
01.01.201838 
02.01.201835 
03.01.201866 
04.01.201873 
05.01.201812 
   
Parking Petrole
   
01.01.201842 
02.01.201835 
03.01.201822 
04.01.201846 
05.01.201833 

and i woul like to transform it in 

DateExitParking
01.01.201850Branchies
02.01.201835Branchies
03.01.201812Branchies
04.01.201855Branchies
05.01.201847Branchies
01.01.201838Allumettes
02.01.201835Allumettes
03.01.201866Allumettes
04.01.201873Allumettes
05.01.201812Allumettes
01.01.201842Petrole
02.01.201835Petrole
03.01.201822Petrole
04.01.201846Petrole
05.01.201833Petrole

 

i have tried a lot of thing but i Don't succeed

i m sure it is easy but 😞

Could you help me please ?

Many thanks and nice end of sunday

Chris

295 Views
0 Likes
0 Replies