Hello,
I have an export from callcenter software and I want to transform it like this.
Original data is on the left and I want to become what's on the right.
What I tried:
Read the source Excel with columns A, B and C as attributes.
Then with a TestFilter I created "Name", "Extension" and "Contents" port but I'm not able to join them.
Any push in the right direction please? :-)
Thanks and stay safe!
-Jonathan
Here's an example of a couple of ways to do it with some mocked up data, using either variable setters and retrievers or adjacent attribute handling. You'd need to do a bit more tidying up of the real data but that should be fairly straightforward
call_report.fmwt
@ebygomm Thank you so much! Learned a lot with the variable setters and retrievers now:-)
@ebygomm Thank you so much! Learned a lot with the variable setters and retrievers now:-)
To be honest I'd nearly always opt for the adjacent attribute handling. Open ended transformers like the variable setters make me uneasy :-)