Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikTonic
Contributor III
Contributor III

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

0 Replies