Dynamic Month Year Column Names Losing Order

[asmith314]

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

[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 · Accepted solution]

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