First 3 rows as Field name

[gauravdang]

Hi,

i am trying to use a concatenate of first three rows to form field header names. i can use dynamic rename to make first row as header but that doesnt solve the purpose.

Example snippet below

 Output required

instead of 6 i am looking for Estimated Gross Profit, then for 7 i want Estimated GP Margin and so on. Similarly for field 12, i want Costs To Date as Field or Header, whichever way you call it.

Thanks in advance.

[gauravdang]

yes the only concern is in summarize tool. Rest everything is fine. Also i tried to mimic the way summarize has been used in your workflow.

[DataNath]

@gauravdang did you try my workflow? Just wondering if you have the same issue as summarize config looks alright.

[grazitti_sapna]

@gauravdang, try this.

Thanks!

[gauravdang]

i was trying to figure out and noted that all fields in summarize tool require change of comma to space bar. it was time consuming but did the work.

Thanks