topic Re: Code breaking after merging 1000 rows in Table tool in Alteryx Designer Desktop Discussions

Code breaking after merging 1000 rows in Table tool

Sumedha992 — Wed, 29 Mar 2023 10:48:52 GMT

Dear Community,

I am trying to merge a set to rows with same data along with another set of data with different values along that same set of first set of data using Table and Layout tools.

Whole workflow is working fine except the point that it is breaking is number of rows in input excel file is more than 1000 and then first cell is getting merged with 9 columns.

Appreciate your help in advance.

Re: Code breaking after merging 1000 rows in Table tool

Sumedha992 — Thu, 06 Apr 2023 09:58:35 GMT

Hi, Please help in getting the resolution.

Re: Code breaking after merging 1000 rows in Table tool

Sumedha992 — Thu, 06 Apr 2023 09:59:53 GMT

Any help would be appreciated.

Re: Code breaking after merging 1000 rows in Table tool

AncientPandaman — Thu, 06 Apr 2023 10:25:09 GMT

I never face this in alteryx. but it looks similar to open text file in excel when they have some newline character or " or ' in between.

to test

try to use multiple field tool (after first select tool) to remove all symbol character.

if it solved mean it got something error character in between, then you can investigate which character cause the problem.

apply for all text columns

formula: regex_replace([_CurrentField_],"[^a-zA-Z0-9]","")

Re: Code breaking after merging 1000 rows in Table tool

Sumedha992 — Thu, 13 Apr 2023 12:33:27 GMT

Appreciate your efforts, but this does not resolve my problem.

Re: Code breaking after merging 1000 rows in Table tool

AncientPandaman — Mon, 17 Apr 2023 10:23:27 GMT

did you mind to share the workflow and data?
remove sensitive data if you want to.

Re: Code breaking after merging 1000 rows in Table tool

arunkumark_21 — Mon, 29 Jul 2024 07:50:11 GMT

Hi Sumedha,

Have you found any resolution to this problem?

I am currently facing the same issue.

Re: Code breaking after merging 1000 rows in Table tool

arunkumark_21 — Mon, 29 Jul 2024 08:25:02 GMT

After doing some trial and error I got a workaround which works for my use case.

The idea is to place the longest table at the beginning. If that is not possible then,

1. Pick one column from the longest table using select and then bring in Table tool

2. Set Column rules to make it as blank as possible-I set all colours in table settings to white.

and replace the data with hairline space.

3. Join with other tables and make this table the first one.

Downside is in excel we will have the first column empty. But this solves the problem.