I'm having trouble loading my data into the Free Wrangler Tool. I have well under 100MB, so it shouldn't be a problem. My excel sheet are 250 columns and a total of 6,000 rows.

[TrifactaUsers]

What is the issue you are facing? it is obvious it will be slower, trying to understand what are the exact issues. Thanks.

[454ea944bff824ea2012]

Only a fraction of the rows actually join in the union. I've also tried re loading the data in various file formats. Each time the data loads, but with different number of rows, none of which are complete.

[TrifactaUsers · Accepted solution]

Did you execute the job to see the final / full result? you might be seeing only the sample data set which would be initial records while writing the recipe's. try executing the job.

[454ea944bff824ea2012]

Yes I've inspected column details, generated reports and the number of records is incomplete. I've tried about a dozen times.

[TrifactaUsers]

is it possible to paste your recipe steps here. I assume you are using Union, which means you have multiple source files and size of all the files is within 100mb.

[454ea944bff824ea2012]

Here it is

[454ea944bff824ea2012]

its the 2.2 that won't load completely.

[TrifactaUsers]

looks good to me, could you pls try the below approach..

1. add 3 version data set into your flow
2. create recipe from 2.2 and use union.
3. In Union, add all the rest of the data set rather than having 3 union steps.
4. Remove duplicates,

Let me know if this works!