Help needed in Qlikview Script / Expression for making in one Row

[lakshmanvepuri]

Hi 

Based on the below tables:

PRODUCT Table:

CHILD Table:

Irrespective of the R_MODE, I want to show in the below format.( Grouping based on the C_CODE )

How do i explicitly pass the values to this in the Qlikview Script or Qlikview Expression.

Thanks

[Oleg_Troyansky · Accepted solution]

You are in luck! QlikView's Table Load wizard allows "rotating" the data - it looks like this is what you need.

When you go through the Table Load wizard, click on the "Enable Transformation" button, and then look for a tab labeled "Rotate". That should solve this problem.

Best,

Oleg Troyansky