Data Prep Query

[Always7Deepak]

Hi Datafam ,

Attaching the image of input and desired output. Can someone please help me to generate the output. Attaching the input file for your reference.I want prices of all Main Course and desserts or what ever category in separate columns and also Total price as separate column for each individual. Thanks in Advance.

Regards,

Deepak

[binu_acs]

@Always7Deepak

[Always7Deepak]

Hi ,

No , I am not looking for biryani price alone. I want my out put as mentioned in the screenshot, I want prices of main course and desserts for all individuals and Total prices as separate columns. Thanks for your response though. 🙂

[binu_acs]

@Always7Deepak 

[Always7Deepak]

Hi ,

Thanks again for your efforts. You are close but the names has to be combined based on the ID. Thanks again so much.

[binu_acs]

@Always7Deepak