topic Load and transform excel file in App Development

Load and transform excel file

QlikTonic — Sun, 28 Jul 2019 15:34:51 GMT

Hi everybody,

I please need your help

I have an excel file with

Parking		Branchies

01.01.2018	50
02.01.2018	35
03.01.2018	12
04.01.2018	55
05.01.2018	47

Parking		Allumettes

01.01.2018	38
02.01.2018	35
03.01.2018	66
04.01.2018	73
05.01.2018	12

Parking		Petrole

01.01.2018	42
02.01.2018	35
03.01.2018	22
04.01.2018	46
05.01.2018	33

and i woul like to transform it in

Date	Exit	Parking
01.01.2018	50	Branchies
02.01.2018	35	Branchies
03.01.2018	12	Branchies
04.01.2018	55	Branchies
05.01.2018	47	Branchies
01.01.2018	38	Allumettes
02.01.2018	35	Allumettes
03.01.2018	66	Allumettes
04.01.2018	73	Allumettes
05.01.2018	12	Allumettes
01.01.2018	42	Petrole
02.01.2018	35	Petrole
03.01.2018	22	Petrole
04.01.2018	46	Petrole
05.01.2018	33	Petrole

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