Analytics Cloud Json Data Import

[dkalyanasundaram]

Hello,

I am trying to import a json file using Analytics Cloud Json Data Import tool. The file contains a large number of fields (~1000) with long names. The data gets imported into appropriate columns when I reduce the number of columns to 500 odd fields. However when it goes beyond these 500 odd fields, all the data get imported into a single column. I am able to accommodate more fields as part of my import if I shorten some of the column names. Is there a limit on the column name of the fields in the data import? Is there a way to overcome this limitation?

Thanks!

[MeganBowers]

Hi @dkalyanasundaram! This documentation indicates you should limit your column lengths to no more than 128 characters when loading data into the cloud platform: https://help.alteryx.com/AAC/en/platform/platform-reference/column-naming-requirements.html#column-n...