Crosstab tool, my input file columns change, how to update it dynamically?

[wonka1234]

Hi,

I am using the crosstab tool. 

Here is my input:

So now the date is not dynamically update in my crosstab tool

Ie previously my input was 202202.. so now when i update to a new file for 202203 it is not automatically ch ecked off..

Is there a way to automatically have these checked in my crosstab tool ? ie if i check 202203 in here, when i update to 202204 it wont be checked,

ALso is it possible to have multiple dates checked? ie if i update to 202204, 202205 it will have both checked!

[mwong]

I have the same situation.  I would appreciate it if anyone can share their ideas

[mwong]

FYI @WO and anyone else researching this, I found this chain and guide helpful for my situation and workflow: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Data-Cleansing/m-p/108... 

[Qiu]

@wonka1234 
Maybe not so common applicable, if your column number is fixed, we can use a mapping file with pre-defined columns names, then rename the inpu file column with Dynamic Rename.

So the CrossTab will received the data with same column names each time.

[Peachyco]

I've attached the Alteryx package that I use for dynamically determining the columns for Cross-Tab grouping. I just slightly modified @BenMoss' work from this related discussion.

Essentially, it's a two-macro process:

1. The first macro builds the XML expression for which columns to group by and passes it to the second macro.
2. The second macro uses the Cross Tab tool, using the XML expression accordingly.

You can pass a dataset with any number of columns to this batch macro. The only rule is that the column to be cross-tabbed must be named [Name], and the column of values must be named [Value] - all the other columns can have any name.