Move the values into new created column

[k3pineapple]

Hi team,

Wondering which function I can use to get this output:

find negative value and move all reverent details to other columns

Input

Date	Value	User	Product
20220910	50	A	Apple
20220913	20	B	Apple
20220915	-30	C	Apple

Output

Date	Value	User	Product	Date1	Value1	User1	Product1
20220910	50	A	Apple	20220915	-30	C	Apple
20220913	20	B	Apple

Thank you

[messi007 · Accepted solution]

@k3pineapple,

Please see below :

Attached the workflow,

Regrads