Code breaking after merging 1000 rows in Table tool

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.

Capture1.PNG

Capture2.PNG

Input.PNG

Workflow_Capture.PNG

Transformation

Accepted answers

All comments

Sumedha992

Hi, Please help in getting the resolution.

Sumedha992

Any help would be appreciated.

AncientPandaman

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.

AncientPandaman

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703