Data import from Excel is incomplete

[sahartz]

Hi All,

Would appreciate your help. I am using the input tool to input data from Excel file, but some of the data is cut.

for example:

Original data in excel: 

To xx with XX XX XX and XX XX requirements, XX operates an XX procedure and customers are entitled to request XX to delete applicable data about them XX XX by laws, regulations and terms and conditions.

A review of the XX procedures identified several discrepancies, including:
1. sfsfsfsfsfxvcxvxvsvxvs
2. sdfsfsfsdfsfsdfsfsfsfsdfsdf.
3. sdfsdfsffgtdtrwvxcvxvsfwet
4. gdfgdsgdfgdfgdgdfgdfgdgdgdg

After importing the data to Alteryx, via the Input tool, the data I see is: 

To xx with XX XX XX and XX XX requirements, XX operates an XX procedure and customers are entitled to request XX to delete applicable data about them XX XX by laws, regulations and terms and cond...

Input tool parameters are:

Could you pls LMK how to solve this issue?

[davidskaife]

Hi @sahartz 

If you put a Browse tool after the Input tool and run the workflow, does the complete data show?

[sahartz]

Hi @davidskaife 

yes, but I don't see the info in the following tools in the flow.

for example - 

 

 When standing on the cell I have this notification - 

 

[davidskaife]

Hi @sahartz 

The answer is in the comment that has popped up - Alteryx will only show a subset of data for a line within the workflow.

The complete data is still there though - which is proved by the Browse tool.

you also have embedded newlines, so worth dropping a Data Cleanse tool on to tidy it up

[sahartz]

@davidskaife but when outputting the data to Excel not all info is exported. in the Excel I see only part of the info 

[davidskaife]

Can you share the workflow and input file?

[sahartz]

unfortunately no :(  The data is sensitive...

I can share the flow if that will help

[davidskaife]

Sure, that'll help check if there is anything wrong with the flow. 

[sahartz]

@davidskaife attached

[davidskaife]

@sahartz 

None of your Output tools are setup from what i can see so cannot check if its an issue with the configuration of those. It's also a relatively large flow to troubleshoot without the data to be honest.

What i think you'll need to do is start outputting the data/adding in Browse tools at various stages to see if the data you're expecting 'disappears' at any point.