Hello,
I am wondering how to make my workflow like below using multirow tool -
If I not count the EL CODE col then Action will be in Odd place and Date Diff will be on Even place.
If anyone could help me, would be great!
Thank you so much!
Solved! Go to Solution.
Hi @Mina2021
Modify your initial workflow like this
The multi-row tools add even column numbers to the top branch and odd ones to the bottom. Crosstab using the column numbers as the column headers and the use a dynamic rename to get the original column headers back.
Dan
Hi danilang,
Can we use other tool instead of cross tab & dynamic rename?
I tried for other workflow which has large number of data and its taking more than 30 mins for running.
Kindly help!
Hi @Mina2021
This new version should run faster since your original version had a crosstab/transpose pair on each branch that you can remove. The new version has a single crosstab at the end
Dan
Hey Dan,
This is really helpful.
Thanks a lot.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |