Unable to UPDATE/UPLOAD file due to MISSING FIELDS

Q&A
,
1

Hello,

I am trying to update the CSV but it is showing the error. Previously i had only 150 fields now in CSV I have 148 fields. Now and in future i want to upload only 148 fields CSV. So how do i achieve this, please find the Snapshot for the Reference.

Best,
Vaibhav Narwade.

2

Hi @Vaibhav.narwade - I believe you can replace the new file while uploading to QuickSight. Can you please share the screenshot for more details.

Regards - Sanjeeb

3

Hi @Sanjeeb2022 ,

Old Data
image

New Data
image

Now I am trying to upload the new Data sheet and it shows error like below

image
image1251×411 31.4 KB

Best,
Vaibhav Narwade.

4

Hi @Vaibhav.narwade - Is it possible to delete the sheet 1 and then upload it again? Give a try.

Regards,
Sanjeeb

5

Hi @Sanjeeb2022 ,

I know dear but i have prepared a report/Analysis.
If i deleted then i have to prepare all from scratch na.

Best,
Vaibhav.

6

Hi @Vaibhav.narwade - Got it. Need to check this and replicate at my end. In parallel, let’s hear from other folks.

Hi @DylanM @duncan - any advise on this?

Regards,
Sanjeeb

7

Hi @Sanjeeb2022,

I think get the solution,
solution is a below
Old Data

image
image1003×396 32.2 KB

New Data

image
image1683×661 46.1 KB

uploaded those 2 datasets seperately

Now replacing the dataset

image
image1298×500 45.9 KB

Replacing with new one
image

it shows ! now
now selecting

need to ignore the field like below
image

Please verify this method.
I don’t know this could work on the linked dataset.

Thank you for your guidance.

8

Hi @Vaibhav.narwade - Yes, this should work as in the analysis you are referring to new data set. However you have 2 datasets available in QS which may not be an efficient approach . This can be consider as a work around solution. Ideally QS should overwrite the existing dataset and refer the update schema.

Regards,
Sanjeeb

1 Like
9

Hi @Sanjeeb2022 ,

Please suggest the best approach.

Best,
Vaibhav.

10

Hi @Vaibhav.narwade

I have basically used the same approach you have taken and it is a smooth transition. When additional columns are added to the excel file, if you keep them at the end then things work fine. The problem is when existing columns are altered or deleted. I don’t see a way around other than the one you have taken.

With relational sources this does not pose a problem and changes in the columns fetched works fine in the dataset and there is a way to deal with them in the analysis.

Regards,
Giri

3 Likes