Multirow

[Mina2021]

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!

[danilang · Accepted 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

[Mina2021]

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!

[danilang]

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 

[Mina2021]

Hey Dan,

This is really helpful.

Thanks a lot.