Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data manipulation challenge

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 MilestoneFlag
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

1 Reply

Re: Data manipulation challenge

See attached example.


talk is cheap, supply exceeds demand
Community Browser