Transpose and Cross Tab

[suby]

Hi All,

I'm facing the issue when i cross tab using the Concatenate. Attached the sample WF.

Looking for some solution on these

- Firstly i when i output from the cross tab I wanted the output to match exactly the same as Input.

[Emmanuel_G]

@suby  Can you please give the excepted output for this input data ?

[Felipe_Ribeir0]

@suby You want the output of the cross tab to look like the text input, right? Like this??

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[binuacs]

@suby to get the exact result as the input you need to turn off the AMP engine and try to run the workflow

[suby]

Hi,

But i how i do get the Original column headers without any Underscores?

[Felipe_Ribeir0]

Hi @suby 

You can use the dynamic rename tool to remove the '_' from the header, see the workflow attached

[Emmanuel_G]

@suby 

Find a solution to get original headers

[Felipe_Ribeir0]

Hi @suby 

It worked?