Increase Data size in alteryx

[praneshsapmm]

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.

[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.

[jimmke7]

Maybe an option to try csv?