Code breaking after merging 1000 rows in Table tool

[Sumedha992]

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.

[Sumedha992]

Hi, Please help in getting the resolution.

[Sumedha992]

Any help would be appreciated.

[Pang_Hee_Choy]

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]","")

[Sumedha992]

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

[Pang_Hee_Choy]

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

[arunkumark_21]

Hi Sumedha,

Have you found any resolution to this problem? 

I am currently facing the same issue.

[arunkumark_21]

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.