dynamic crosstab

[PrasadP]

Hi community,

How to make the cross tab tool dynamic so that if any new fields are coming in the input stream, it should go into 'Group data by' section in the cross tab.

Regards,

Prasad

[BenMoss]

Yes it's possible, but requires a bit of setting up into a batch macro.

Could you please share a sample workflow that I can work from.

Ben

[PrasadP]

Hi @BenMoss ,

Thank you..

Please see the attached. I need to make the cross tab dynamic so that if any new column(Criteria D in the sample data) is added it goes into the 'Group by'.

Thanks,

Prasad

[BenMoss · Accepted solution]

Here you go...

If you add new fields they should automatically be captured.

Ben

[PrasadP]

Hi @BenMoss ,

Thanks for the solution.

Regards,

Prasad