Data manipulation challenge

Fri, 28 Jun 2013 00:30:27 GMT

I have the following data sturctured in the below format (don't ask me why its in this format )

Enhancement	Milestone
E_A
E_B
E_C
	M1
	M2
	M3
E_D
E_E
	M1
	M2

I have request to tag any enhancements that have corresponding Milestones underneath. For example, i wouldn't tag E_A or E_B because they don't any corresponding milestones underneath. However I would tag E_C and E_E.

Hi QV developers,

I have to come up with the below structure:

Enhancement	Milestone	Flag
E_A		0
E_B		0
E_C		1
	M1
	M2
	M3
E_D		0
E_E		1
	M1
	M2

Please advise. Thanks for your time.

Regards

Thomas

Re: Data manipulation challenge

Gysbert_Wassenaar — Fri, 28 Jun 2013 06:20:06 GMT

See attached example.

topic Re: Data manipulation challenge in QlikView

Data manipulation challenge

Re: Data manipulation challenge