First 3 rows as Field name

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.

Workflow

Accepted answers

IraWatt

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

All comments

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

Workflow.yxmd

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:

Top 3 rows as name.yxmd

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

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

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_workflow.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703