OK, one more today, hoping to finish this data output today.
I have to transpose this:
Transaction Type | Benefit Month | code 5601 | code 5602 | code 5603 | code 5604 |
TRN | 12/18/2018 | 175.5 | 48 | ||
PRK-CR | 12/18/2018 | 50 | 0 |
Into this:
Transaction Type | Benefit Month | ||
TRN | 12/18/2018 | code 5601 | 175.5 |
TRN | 12/18/2018 | code 5602 | 48 |
TRN | 12/18/2018 | code 5603 | |
TRN | 12/18/2018 | code 5604 | |
PRK-CR | 12/18/2018 | code 5601 | |
PRK-CR | 12/18/2018 | code 5602 | |
PRK-CR | 12/18/2018 | code 5603 | 50 |
PRK-CR | 12/18/2018 | code 5604 | 0 |
I can transpose the data fine but I can't figure how to get the "code" field headers to be included in the new rows.
Solved! Go to Solution.
OK, it works! It wasn't the transpose function that was the trouble. It was one of the downstream select functions that went wonky and I just didn't see it. Sorry to bother folks, normally I would be more careful in checking everything before asking for help but I was running out of time and a little desperate. Anyway, thanks for all of the replies! Hopefully one day I will be good enough at this to help someone else.
Here is the final workflow.