Remove columns with no data after Table tool?

[jvaucher0804]

Hello!

I'm trying to remove columns with no data after doing a crosstab then grouping by customer # and creating specific table for each customer.

Coming up with no success. Any insights/tips would greatly be appreciated.

[PhilippK]

Hello @jvaucher0804 ,

yes this is possible, you have to split your rows/group-by results first, and then create a table for each.

please find an example attached.Best regards

Phil

[messi007]

Dear @jvaucher0804 ,

You can do that with a macro Batch.

Attached the macro and the workflow.

Hope that Helps!

Regards,