topic Help with moving data from cell into a another cell in Alteryx Designer Desktop Discussions

Help with moving data from cell into a another cell

HassimDiallo — Mon, 03 Feb 2025 20:01:01 GMT

Hello _ i need help from this community.

I am working with a excel file and need issue i am facing is in Yellow. Desire state is in Green.

In row C5 the full name should be Balance & Compensation Information. However information is getting cut to a different row C6.

Same for C7- C8: full name should be Account Maintenance W/ Chk Return. Return is on the next cell below

Same for C15 - C16: full name is General Account Services Updated

was hoping to use Multi-Row Formula to solve for it. What can i use to reach my desire highlighted in Green? Which is copying Information and any of the words in Red and append them at the end of previous non blank cell.

IF !ISNULL([Service Description]) and ISNULL([AFM Code]) and ISNULL([XYZ Code])
Then [Service Description] + " " + [Row-1:Service Description]
Else [Service Description]
ENDIF

Re: Help with moving data from cell into a another cell

The_Rad_Valentina — Mon, 03 Feb 2025 21:01:39 GMT

Here's the formula you should use that will do the trick.

IF Contains([Service Description],"…")

Then Trim(REGEX_Replace([Service Description], "\…\.*","")) + " " + Trim([Row+1:Service Description])

Else Trim([Service Description])

ENDIF

If this works for you, please accept this as a solution.

Re: Help with moving data from cell into a another cell

HassimDiallo — Tue, 04 Feb 2025 18:34:51 GMT

@The_Rad_Valentina , Thank you for the below. This is definitely the idea but not quite. I need to clarify few points.

the ..... (red dots)does not exist in my data. i wanted to show you information highlighted in red needed to be moved where the dots are in order for the correct output to show Balance and Compensation Information.
logic is to only make the change where service description has data and AFM Code and XYZ code are blank the date under [Row+1: service description] should be copied and pasted at the end of [Row+0: Service Description]. IE: Information needs to be copied and merge with Balance & Compensation to make Balance & Compensation Information.
could you please copy your sample data set in a text input file and share sample of workflow again. I wasnt able to run the file because of the input file directory.

Thank you so much and kind regards,

Hassim

Re: Help with moving data from cell into a another cell

The_Rad_Valentina — Tue, 04 Feb 2025 19:38:28 GMT

@HassimDiallo Try this formula in the MultiRow tool

IF isnull([Row+1:AFM Code]) AND isnull([Row+1:XYZ Code]) AND isnull([Row+1:Unit Price]) Then Trim([Service Description]) + " " + Trim([Row+1:Service Description]) Else Trim([Service Description]) ENDIF

Re: Help with moving data from cell into a another cell

The_Rad_Valentina — Thu, 06 Feb 2025 13:38:28 GMT

Here's the workflow, let me know if this solves your question.

Please accept the response as a solution if it does.

Thank you,

Valentina

Re: Help with moving data from cell into a another cell

HassimDiallo — Thu, 06 Feb 2025 13:58:07 GMT

@The_Rad_Valentina Thank you! I am reviewing the proposed and will revert.