I have a dataset with a field called BM. There could be n number of Business Managers for each Identifier at given point of time. I am transposing the data to get different fields as BM1, BM2, BM3 and so on. I want fields upto BM5 even if BM4 and BM5 doesn't exists. For example IdentifierBM 1Steve 1Neha 1Richard 2Usha 2Mandy 2Nancy Output IdentifierBM1BM2BM3BM4BM51SteveNehaRichard 2UshaMandyNancy I want BM4 and BM5 as blank columns even if there is no data. Any kind of help would be appreciated. Best Pooja

Fields with no data

I have a dataset with a field called BM. There could be n number of Business Managers for each Identifier at given point of time. I am transposing the data to get different fields as BM1, BM2, BM3 and so on. I want fields upto BM5 even if BM4 and BM5 doesn't exists. For example

Identifier	BM
1	Steve
1	Neha
1	Richard
2	Usha
2	Mandy
2	Nancy

Output
Identifier	BM1	BM2	BM3	BM4	BM5
1	Steve	Neha	Richard
2	Usha	Mandy	Nancy

I want BM4 and BM5 as blank columns even if there is no data.

Any kind of help would be appreciated.

Best

Pooja

Workflow

Dynamic Processing

Accepted answers

binu_acs

@Analytics_Pooja

Tranpose1.yxmd

All comments

gabrielvilella

Hey @Analytics_Pooja, here is one way you can do this.

BM.yxmd

Qiu

@Analytics_Pooja
here is my try.

0322-Analytics_Pooja.yxmd

Analytics_Pooja

@gabrielvilella transposing data is not a problem. Problem is to create BM4 and BM4 that doesn't exist in the current data but likely to get populated in next data.

binu_acs

@Analytics_Pooja

Tranpose1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703