column combination

Hi all,

I have an excel table including logistics activities such as
1.truck arrival at plant
2. truck departure from plant
3. truck arrival at destination
4. truck depart from destination.
Each activities have date and time seperately. For example, columnA = truck arrival at plant date , columnB = truck arrival at plant time

That means I have 8 columns. The objective is to combine column A with B, and C with D, and E with F so on.

So far I have learned column combiner node, but I have to do it repeatedly.

Do you guys have any recommendations?

You could try the Column Aggregator node. Depending on your requirements you might want to change the format of originals before aggregating them.

2 Likes