Increase Data size in alteryx

Hello there,

I have this issue while downloading data from In-DB tools .

Iam using Alteryx Designer IN- DB tools to query some information from SQL Server (front end SAP). Whenever the data is downloaded (.xlsx) it is huge as compared to the same data set extracted from SAP front end .

When i looked into the data there are no blank spaces / nothing unsual .

Any clue why is this happening .

Also i am trying to convert .xlsx file to .xlsb , the size of the file has deceased but not upto what i require.

Thanks.

Database Connection

Accepted answers

All comments

Emil_Kos

Hi @praneshsapmm,

As the first step, I would suggest using the auto field tool to make sure that your metadata is correct.

As the second step, I would suggest joining all the data sets together on each of the columns.

Thanks to that you will be able to identify the difference if all the data is correct and all the data is exactly the same please let us know.

In my opinion, the first or the second advice will allow you to identify the issue.

praneshsapmm

Hi @Emil_Kos

What do you mean by joining all the data sets .

Also how does auto tool help .

Thanks.

Emil_Kos

Hi,

You can join those two outputs from two different data sources to compare if they are exactly the same.

In order to do so you can use the join tool and join the data on each column:

If there will be any differences you will be able to identify them thanks to that.

praneshsapmm

Hi @Emil_Kos

I have included auto field . But still it is same .

Emil_Kos

Hi @praneshsapmm,

Did you join those two data sets to check if they are really exactly the same?

praneshsapmm

Hi @Emil_Kos ,

No , instead i checked the file size of both the files . It is same .

One file without auto field and one with auto field.

Thanks.

Emil_Kos

Hi @praneshsapmm,

From my understanding, you got 2 output files from 2 different sources. You think they are exactly the same but you didn't check if they are.

The auto field option goal was to check if the data seize wasn't increased by the incorrect data types.

The join tool goal was to check if the data sets are exactly the same.

Please check(using join tool) if they are exactly the same as I believe there might be differences and that is why you see the difference in the size of the file.

praneshsapmm

Hi @Emil_Kos ,

No no .. that is not the requirement .

I have a particular data set extracted from SQL Server . It is above 15 MB .

Now the same dataset extracted from from SAP front end ,it is less than 15 MB .

How to extract same file size from SQL Server via Alteryx .

We cannot upload files more than 15MB in our upstream system .So is the requirement .

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703