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.

[IraWatt]

Hey @gauravdang,

Heres a simple way to do this:

I used the summery tool to concatenate the field names:

Any questions or issues please ask :)
HTH!
Ira

[IraWatt]

Can you link attach your example data @gauravdang ?

[DataNath]

Here's one way I can think to do it, ought to be fully dynamic as well:

[gauravdang]

Thanks for the response. this is super helpful. Once query though, when using summarize tool, and then concantenate i removed "," and replaced with a space, however i still see commas.

[IraWatt]

Hey @gauravdang, 

can you show the configuration of you summarize tool? Or attach your workflow or sample data?

[gauravdang]

Note that Separator box has been tested as blank, with space and with comma. All spit out the same result.

[IraWatt]

@gauravdang that seems good, and if you click on the concatenate for field 1 and 2 it is the same?

[gauravdang]

Yes.

[IraWatt · Accepted solution]

@gauravdang Does the workflow I sent over do the same?