Dynamic Month Year Column Names Losing Order

Hello Everyone,

Hoping someone could assist

I have a couple of data streams where I am pulling in counts/sums of values by dates, formatting the dates, then making those date formats headers.

Workflow zip file attached with YXDB sample data sets

Basically the data looks like this

Everything appears to be fine UNTIL I union the values

Am I going about this the wrong way? Can I make this way work or should I got a different direction to accomplish the same goal

NOTES:

On my original workflow, the user will input a begin date and end date so for example: it could just be for Jun_22 to Aug_22 or Jul_23 to Sep_25 and may not include the entire year or one single year for that matter. Hope that helps clarify.

Thanks

DynamicColumnNames.yxzp

Workflow

Transformation

Dynamic Processing

Accepted answers

Luke_C

Hi @asmith314

Might be a quirk of the union, but I swapped the #1 and #2 connections and it seems to work?

All comments

asmith314

I'm sure most probably know this but just in case, if you change the file extension to .zip instead of .yxzp it will allow you to extract it with Windows.

Luke_C

Hi @asmith314

Might be a quirk of the union, but I swapped the #1 and #2 connections and it seems to work?

dsandmann

@Luke_C - yes, I believe within the order of operations on the unions, it always takes the original schema from the #1 connection.

asmith314

Wow crazy how simple that was, I tested this against multiple date ranges in my original data set and the connection order was the issue.

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703